https://community.qlik.com/t5/App-Development/Partitioned-Rank-by-multiple-dimensions/m-p/1953208#M78609 <P>Hi Community,</P> <P>My ultimate goal is to only show the top N lines on a map for each group.</P> <P>My approach is to define a rank variable and use that to select the top N to filter in the map view.</P> <P>I would like to create a rank variable that ranks a subset of the table based on multiple dimensions (attached) and shown below. Rank is partitioned across the "Year", "Quarter" and "Cluster" variables</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Matt_M_0-1657264297230.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83614i764DE6FCB8949344/image-size/medium?v=v2&amp;px=400" role="button" title="Matt_M_0-1657264297230.png" alt="Matt_M_0-1657264297230.png" /></span></P> <P>I have tried two forms of the rank function:</P> <OL> <LI>rank(sum(pax_count)), which produces 1 for every row</LI> <LI>aggr(rank(sum(pax_count)), 'Year') produces nulls</LI> </OL> <P>How can i define a rank variable partitioned across multiple dimensions?&nbsp;</P> <P>Thanks for any help</P> Fri, 08 Jul 2022 07:21:43 GMT Matt_M 2022-07-08T07:21:43Z https://community.qlik.com/t5/App-Development/Partitioned-Rank-by-multiple-dimensions/m-p/1953208#M78609 <P>Hi Community,</P> <P>My ultimate goal is to only show the top N lines on a map for each group.</P> <P>My approach is to define a rank variable and use that to select the top N to filter in the map view.</P> <P>I would like to create a rank variable that ranks a subset of the table based on multiple dimensions (attached) and shown below. Rank is partitioned across the "Year", "Quarter" and "Cluster" variables</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Matt_M_0-1657264297230.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83614i764DE6FCB8949344/image-size/medium?v=v2&amp;px=400" role="button" title="Matt_M_0-1657264297230.png" alt="Matt_M_0-1657264297230.png" /></span></P> <P>I have tried two forms of the rank function:</P> <OL> <LI>rank(sum(pax_count)), which produces 1 for every row</LI> <LI>aggr(rank(sum(pax_count)), 'Year') produces nulls</LI> </OL> <P>How can i define a rank variable partitioned across multiple dimensions?&nbsp;</P> <P>Thanks for any help</P> Fri, 08 Jul 2022 07:21:43 GMT https://community.qlik.com/t5/App-Development/Partitioned-Rank-by-multiple-dimensions/m-p/1953208#M78609 Matt_M 2022-07-08T07:21:43Z https://community.qlik.com/t5/App-Development/Partitioned-Rank-by-multiple-dimensions/m-p/1955301#M78781 <P>Perhaps what you need is the following to achieve your objective?</P> <UL> <LI><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/Grouping-measure-data-into-ranges.htm" target="_blank">Grouping measure data into ranges</A></LI> </UL> Wed, 13 Jul 2022 14:19:11 GMT https://community.qlik.com/t5/App-Development/Partitioned-Rank-by-multiple-dimensions/m-p/1955301#M78781 Frank_S 2022-07-13T14:19:11Z