QlikView for Developers Cookbook

Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion

AGGR is very useful for advanced aggregations. However, we need to be careful when using it in charts that have a Group dimension; either cycle or drill.

In this recipe, we will see how to overcome this using a Dollar Expansion.

Getting ready

This example follows along from the previous section. Load the data and create the straight table with the AGGR expression.

How to do it...

Follow these steps to create a dynamic AGGR expression for a group dimension:

1. In Document Properties | Groups, create a group called Cycle1 with ProdID and Month as the dimensions:
   
2. Edit the straight ...