How to use the Cyclic Group along with Aggr function to dynamically recalculate charts based on the selected group Value

[QlikNAM]

Qlik have introduced the Cyclic group to Qlik Sense Cloud, Which is a fantastic addition for you to dynamically change the dimension based on the cyclic group.. This opens the doors to dynamically use the the Cyclic group in Aggregation function in a calculation.

• Create a Cyclic group with the required Dimension values . EG Locations.
• Create a Variable in the script to get the label of the group dimension created above (Note the single quotes and the = inside , very important for the $ expand to compute the values from the cyclic field name selected

set vLocations = '=GroupDimensionLabel(Locations)';

• Use the variable inside your formula

Aggr(Rank(1-count({<[somefield]={'somevalue'}>}some_number)/count(some_number)),$(vLocations))