topic Re: Rank for 2 levels in text box in QlikView https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142988#M462832 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>Thanks so much for always being so helpful!</P></BODY></HTML> Sat, 20 Aug 2016 12:26:37 GMT dafnis14 2016-08-20T12:26:37Z Rank for 2 levels in text box https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142986#M462830 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem to achieve the following:</P><P></P><P>I have a shop which is linked to an area.</P><P>I would like to show for a selected shop two figures in two separate text objects:</P><P>1 - the shop's rank in the area it belongs to</P><P>2- the shop's rank in all the chain</P><P>Attached is a very small sample data.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Sat, 20 Aug 2016 12:11:32 GMT https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142986#M462830 dafnis14 2016-08-20T12:11:32Z Re: Rank for 2 levels in text box https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142987#M462831 <HTML><HEAD></HEAD><BODY><P>Try these:</P><P></P><P><STRONG>='Overall Rank :' &amp; Aggr(Rank(TOTAL Sum({1}Sales)), Area, Shop)</STRONG></P><P><STRONG>='Rank in Area :' &amp; Aggr(Rank(TOTAL Sum({&lt;Shop, Area = p(Area)&gt;}Sales)), Area, Shop)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135088_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sat, 20 Aug 2016 12:16:53 GMT https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142987#M462831 sunny_talwar 2016-08-20T12:16:53Z Re: Rank for 2 levels in text box https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142988#M462832 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>Thanks so much for always being so helpful!</P></BODY></HTML> Sat, 20 Aug 2016 12:26:37 GMT https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142988#M462832 dafnis14 2016-08-20T12:26:37Z Re: Rank for 2 levels in text box https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142989#M462833 <HTML><HEAD></HEAD><BODY><P>No problem at all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 20 Aug 2016 12:28:04 GMT https://community.qlik.com/t5/QlikView/Rank-for-2-levels-in-text-box/m-p/1142989#M462833 sunny_talwar 2016-08-20T12:28:04Z