topic Re: Reverse Rank() in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852399#M298850 <HTML><HEAD></HEAD><BODY><P>Use this:</P><P></P><P><STRONG>Rank(-Sum(Value))</STRONG> to get reverse order ranking</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 30 Jun 2015 12:07:07 GMT sunny_talwar 2015-06-30T12:07:07Z Reverse Rank() in Qlikview https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852398#M298849 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>As you know the RANK() function return the RANK in largest value bases. how can i get rank() on lowest base.</P><P>ex lowtest get rank 1 and so on</P><P></P><P>Regards,</P><P>JKV</P></BODY></HTML> Tue, 30 Jun 2015 12:05:45 GMT https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852398#M298849 2015-06-30T12:05:45Z Re: Reverse Rank() in Qlikview https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852399#M298850 <HTML><HEAD></HEAD><BODY><P>Use this:</P><P></P><P><STRONG>Rank(-Sum(Value))</STRONG> to get reverse order ranking</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 30 Jun 2015 12:07:07 GMT https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852399#M298850 sunny_talwar 2015-06-30T12:07:07Z Re: Reverse Rank() in Qlikview https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852400#M298851 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Tue, 30 Jun 2015 12:09:12 GMT https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852400#M298851 2015-06-30T12:09:12Z Re: Reverse Rank() in Qlikview https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852401#M298852 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Glad I was able to help.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 30 Jun 2015 12:10:14 GMT https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852401#M298852 sunny_talwar 2015-06-30T12:10:14Z Re: Reverse Rank() in Qlikview https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852402#M298853 <HTML><HEAD></HEAD><BODY><P>Hii</P><P>Try like this:IF(Aggr(Rank(-SalesValue),Cust_ID)&lt;=5,(SalesValue))</P><P></P><P>This gives the lowest 5 sales based customers.</P><P>Hope this helps.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 30 Jun 2015 12:11:04 GMT https://community.qlik.com/t5/QlikView/Reverse-Rank-in-Qlikview/m-p/852402#M298853 prajapatiamar38 2015-06-30T12:11:04Z