Qlik Sense is a modern business intelligence and data analytics platform by Qlik that enables self-service visualization, exploration, and discovery through its associative analytics engine. Unlike traditional query-based BI tools, Qlik Sense reveals hidden insights by highlighting relationships across all data—showing not only what matches your selections but also what doesn't. The platform supports both guided analytics (pre-built apps and dashboards) and ad-hoc exploration, including AI-powered Insight Advisor for natural language queries, making it valuable for analysts, business users, and developers alike. Mastering set analysis, data modeling, scripting fundamentals, and the newer Window functions will unlock Qlik Sense's full analytical power across cloud and on-premises deployments.
What This Cheat Sheet Covers
This topic spans 21 focused tables and 232 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
Table 1: Core Aggregation Functions
Aggregation is the heart of every Qlik measure—these functions collapse many rows into a single number across whatever the user has selected. Beyond the everyday Sum and Count, the real power sits in Aggr, which builds a virtual table so you can nest one aggregation inside another, and the TOTAL qualifier, which lets a calculation ignore the chart's dimensions to compute shares and percentages.
| Function | Example | Description |
|---|---|---|
Sum(Sales) | Calculates the total of all values in the specified field or expression. | |
Count(OrderID) | • Returns the number of values • use Count(DISTINCT Field) to count unique values only. | |
Avg(Price) | Calculates the arithmetic mean of all values in the expression. | |
Min(Date) | Returns the minimum value from the set of values. | |
Max(Quantity) | Returns the maximum value from the set of values. | |
Only(Region) | • Returns the field value if exactly one distinct value exists • otherwise returns NULL—useful for dimensional aggregates. |