https://community.qlik.com/t5/App-Development/How-to-use-the-Cyclic-Group-along-with-Aggr-function-to/m-p/2450226#M97907 <P>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.</P> <UL> <LI>Create a Cyclic group with the required Dimension values . EG Locations.</LI> <LI>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</LI> </UL> <P>set vLocations = '=GroupDimensionLabel(Locations)';</P> <UL> <LI>Use the variable inside your formula</LI> </UL> <P>Aggr(Rank(1-count({&lt;[somefield]={'somevalue'}&gt;}some_number)/count(some_number)),$(vLocations))</P> Wed, 08 May 2024 09:15:35 GMT QlikNAM 2024-05-08T09:15:35Z https://community.qlik.com/t5/App-Development/How-to-use-the-Cyclic-Group-along-with-Aggr-function-to/m-p/2450226#M97907 <P>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.</P> <UL> <LI>Create a Cyclic group with the required Dimension values . EG Locations.</LI> <LI>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</LI> </UL> <P>set vLocations = '=GroupDimensionLabel(Locations)';</P> <UL> <LI>Use the variable inside your formula</LI> </UL> <P>Aggr(Rank(1-count({&lt;[somefield]={'somevalue'}&gt;}some_number)/count(some_number)),$(vLocations))</P> Wed, 08 May 2024 09:15:35 GMT https://community.qlik.com/t5/App-Development/How-to-use-the-Cyclic-Group-along-with-Aggr-function-to/m-p/2450226#M97907 QlikNAM 2024-05-08T09:15:35Z