Qlik Sense Advanced Scripting

2 Days
£1000 + VAT (per person)

Audience

For anyone that has attended a first level Qlik Sense or QlikView data modelling or developer course, or understands the basic principles and Qlik data modelling.

Expectations

By the end of the course you should have a clear understanding of the advanced techniques so that you can apply them to your own implementations.

Equipment

To attend this course you will need to bring a laptop running Windows and have either Qlik Sense Desktop installed or have rights on your laptop to be able to connect to the room WiFi.

Course Outline

This course is spread over two days and looks into the following topics. All topics are presented in a course book also acting as a reference guide.

  • Internal data storage
  • Data cleansing methods
  • Direct Discovery
  • Dealing with hierarchies
  • Sampling data
  • Handling slowly changing dimensions
  • Solve with Link tables
  • Useful  loops
  • Conditional and dynamic script
  • String manipulation
  • Load and comparing data rows
  • Useful date and time functions
  • Derived fields
  • QVD architecture and Incremental loads
  • Importing external expressions
  • Generating rolling 12 month data
  • Additional advanced concepts