Using the expressions loaded in the script, the UI should perform aggregations on the finest grain on the fly; for example:
- If your application should allow users to drill into the detail of individual transactions, but you want a chart to aggregate transactions by customer, this aggregation should be done by a Qlik chart or expression.
- If you require point-in-time comparisons (such as year on year), then perform these within your Qlik Sense charts by using set analysis.
- Any calculation that would be hard to aggregate if done at a granular level. An example of this can be ratios calculations. As ratios are not additive, calculating them at the lowest grain makes it tricky to aggregate.
The previous examples do ...