Courses
Advanced Scripting - Level 1

Advanced Scripting - Level 1

Learn advanced data modelling techniques to solve common problems and understand how Qlik stores data.

This course is for anyone that understands the basics of creating a load script and wants to take it to the next level.

To complete this course, you'll need to have Qlik Sense Desktop installed.

Approx 4 hours

Lessons

1 - Qlik Data Storage
Learn how a Qlik app stores data internally.
U
2 - Using KEEP
Discover how to use the Keep prefix to control data loaded from source based on existing data in the data model.
U
3 - Hierarchy & HierarchyBelongsTo
Use the hierarchy prefixes to convert source hierarchy data into a more usable format.
U
4 - IntervalMatch
Learn how to use IntervalMatch to match discrete data with interval data.
U
5 - Loops
Learn how to use loops to iterate over statements multiple times, with changing values and parameters.
U
6 - IterNo and Subfield Loops
Use IterNo and Subfield to create additional data and tables using data from existing fields/tables.
U