Introduction
Qlik Sense relies on a unique associative engine that enables data exploration without predefined queries. In 2026, businesses demand applications that handle massive data volumes while maintaining sub-second response times. This tutorial covers the theoretical foundations of the extended star schema, association graph optimization, and cardinality reduction strategies. The goal is to transform a standard application into a scalable and maintainable analytical tool.
Prerequisites
- In-depth knowledge of the relational data model
- Practical experience with Qlik Sense Desktop or Enterprise
- Understanding of cardinality and join concepts
- Access to a Qlik Sense development environment
Understanding the Associative Engine
The Qlik engine automatically associates all tables through common fields. This approach differs radically from classic star schemas: each selection creates a dynamic context. In practice, a poorly named linking field can generate invisible association loops and triple memory consumption.
Building an Optimal Data Model
Systematically adopt the constellation model: a central fact table surrounded by denormalized dimensions. Eliminate synthetic keys by creating readable composite keys. Measure the impact of each added table on the .qvf file size before validating the model.
Mastering Set Analysis
Set analysis allows ignoring user selections through modifiers. Use the $ and 1 identifiers judiciously. A poorly constructed expression can force a complete recalculation of the associative graph on every click, severely degrading performance.
Best Practices
- Always load data in logical dependency order
- Use variables for repeated expressions
- Limit the number of calculated fields in fact tables
- Document every table and field in the script
- Test performance after each major model change
Common Mistakes to Avoid
- Creating synthetic keys by omitting composite keys
- Forgetting to treat dates as dimensions rather than facts
- Ignoring the memory impact of long text fields
- Multiplying complex Set Analysis expressions without optimization
Going Further
Deepen these concepts in our certified training courses. Discover the full program on Learni Group.