https://community.qlik.com/t5/QlikView/Rank-on-SubTotal-with-respect-to-Grand-total/m-p/1762566#M717952 <P>Hello ,</P><P>&nbsp;</P><P>Could you please help to get a rank like for Example</P><P>Country -France , Rank of City would be Paris = 1,Lyon=2, Nice=3</P><P>but SubTotal rank would be 2 as it is 29.49% according to Grand total.</P><P>I have attached the document</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="akar_0308_0-1605702154699.png" style="width: 648px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44372i17CAAC636DAEEAD2/image-dimensions/648x337?v=v2" width="648" height="337" role="button" title="akar_0308_0-1605702154699.png" alt="akar_0308_0-1605702154699.png" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 17:48:46 GMT akar_0308 2024-11-16T17:48:46Z https://community.qlik.com/t5/QlikView/Rank-on-SubTotal-with-respect-to-Grand-total/m-p/1762566#M717952 <P>Hello ,</P><P>&nbsp;</P><P>Could you please help to get a rank like for Example</P><P>Country -France , Rank of City would be Paris = 1,Lyon=2, Nice=3</P><P>but SubTotal rank would be 2 as it is 29.49% according to Grand total.</P><P>I have attached the document</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="akar_0308_0-1605702154699.png" style="width: 648px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44372i17CAAC636DAEEAD2/image-dimensions/648x337?v=v2" width="648" height="337" role="button" title="akar_0308_0-1605702154699.png" alt="akar_0308_0-1605702154699.png" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 17:48:46 GMT https://community.qlik.com/t5/QlikView/Rank-on-SubTotal-with-respect-to-Grand-total/m-p/1762566#M717952 akar_0308 2024-11-16T17:48:46Z https://community.qlik.com/t5/QlikView/Rank-on-SubTotal-with-respect-to-Grand-total/m-p/1762802#M717957 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/129936">@akar_0308</a>&nbsp;</P><P>Try like below</P><P>If(RowNo()=0, Aggr(Rank(Sum(TOTAL&lt;Country&gt; [Count of Sales])), Country), Aggr(Rank(Sum( [Count of Sales]),4,1),Country, City))</P><P>output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1605774493752.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/44429i4A60D3015BC812FF/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1605774493752.png" alt="MayilVahanan_0-1605774493752.png" /></span></P><P>&nbsp;</P> Thu, 19 Nov 2020 08:28:25 GMT https://community.qlik.com/t5/QlikView/Rank-on-SubTotal-with-respect-to-Grand-total/m-p/1762802#M717957 MayilVahanan 2020-11-19T08:28:25Z