Category: Learning Paths & Courses

Set Analysis is a powerful syntax in Qlik that lets you apply calculations to specific subsets of your data — often 3-8x faster than a traditional IF() function. This guide covers Set Analysis fundamentals, Dollar-Sign Expansion, Set Operators, AGGR(), and the flag method for ultimate performance.

28 articles that take you from beginner to Qlik Sense Data Architect. Learn to load data, build optimal data models, tune performance, and implement enterprise architectures. What is the Qlik Sense Data Modeling Course? This course covers all key aspects of Qlik Sense data modeling – from your first LOAD statement to complex enterprise architectures with the Three-Stage Pattern, performance tuning…

Qlik Sense Course – Article 16 of 28. What is IterNo()? A counter function that returns the current iteration number (1, 2, 3…) in WHILE loops – perfect for date ranges, sequences, and record expansion! Learn how to use the power trio of IterNo() + AUTOGENERATE + WHILE for generating sequences and expanding records.

📚 Qlik Sense Course – Article 15 of 28 ← Previous Article: Time-Based Data – IntervalMatch & Calendar → Next Article: IterNo() & AUTOGENERATE Patterns What is a Master Calendar? A Master Calendar is a complete, gap-free table of all date values with pre-calculated time dimensions (Year, Quarter, Month etc.) – for performance and consistent time analysis. What you…

Qlik Sense Course – Article 14 of 28. What is IntervalMatch? A special Qlik function that automatically maps individual points in time (e.g., sale date) to time periods (e.g., budget periods) – without complex JOINs. Learn IntervalMatch, Master Calendar generation, Date Island patterns, and fiscal year handling.

Qlik Sense Course – Article 13 of 28. What is SCD Type 2? A method for historizing dimension changes. When a customer switches regions, the old version is kept and a new one is created – keeping historical analyses accurate. Learn how to implement SCD2 with hash-based change detection, surrogate keys, and point-in-time lookups.

Qlik Sense Course – Article 12 of 28. What is a Link Table? A Link Table (also called Bridge Table) resolves many-to-many relationships: one customer buys multiple products, one product is bought by multiple customers. The Link Table connects both sides cleanly – without Synthetic Keys! Learn how to build composite keys and optimize performance.

Qlik Sense Course – Article 11 of 28. What is the difference between Fact and Dimension? Facts contain transactional, measurable data (revenue, quantities) – they answer ‘What happened?’. Dimensions contain descriptive data (customer, product) – they answer ‘Who/What/Where/When?’. Learn how to classify tables correctly and design performance-optimal data models.

Qlik Sense Course – Article 10 of 28. Learn how to implement star schema architecture in Qlik for 3-8x better expression performance, reduce memory consumption by 40-60%, and model clean business hierarchies without circular references or synthetic keys. Covers Simple Star, Multiple Facts, and Conformed Dimensions patterns.

Learn how to identify and resolve synthetic keys and circular references in Qlik Sense data models. This guide covers field renaming strategies, architectural decoupling, preventive naming conventions, and troubleshooting common data modeling problems.