topic ranking in QlikView https://community.qlik.com/t5/QlikView/ranking/m-p/1117388#M368729 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i need to have some label that when i click on each branch id, it shows the rank of the sale</P><P>for example my data like this:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Branch_ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sale</STRONG></TH></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1250</TD></TR><TR><TD style="padding: 2px;">101</TD><TD style="padding: 2px;">1452</TD></TR><TR><TD style="padding: 2px;">103</TD><TD style="padding: 2px;">1301</TD></TR></TBODY></TABLE><P></P><P>when i click on 101 my lable should show 1 and when i click on 100 it should show 3</P><P>what should i do?</P></BODY></HTML> Wed, 15 Jun 2016 05:33:03 GMT omid5ive 2016-06-15T05:33:03Z ranking https://community.qlik.com/t5/QlikView/ranking/m-p/1117388#M368729 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i need to have some label that when i click on each branch id, it shows the rank of the sale</P><P>for example my data like this:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Branch_ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sale</STRONG></TH></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1250</TD></TR><TR><TD style="padding: 2px;">101</TD><TD style="padding: 2px;">1452</TD></TR><TR><TD style="padding: 2px;">103</TD><TD style="padding: 2px;">1301</TD></TR></TBODY></TABLE><P></P><P>when i click on 101 my lable should show 1 and when i click on 100 it should show 3</P><P>what should i do?</P></BODY></HTML> Wed, 15 Jun 2016 05:33:03 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/1117388#M368729 omid5ive 2016-06-15T05:33:03Z Re: ranking https://community.qlik.com/t5/QlikView/ranking/m-p/1117389#M368730 <HTML><HEAD></HEAD><BODY><P><EM>May be this,</EM></P><P></P><P><EM>='Rank ' &amp; Num(Aggr(Rank(Sum({1} Sale),4),Branch_ID))</EM></P></BODY></HTML> Wed, 15 Jun 2016 05:49:38 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/1117389#M368730 tamilarasu 2016-06-15T05:49:38Z Re: ranking https://community.qlik.com/t5/QlikView/ranking/m-p/1117390#M368731 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I hope it will helpful for you.</P></BODY></HTML> Wed, 15 Jun 2016 05:55:14 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/1117390#M368731 muthukumar77 2016-06-15T05:55:14Z Re: ranking https://community.qlik.com/t5/QlikView/ranking/m-p/1117391#M368732 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P>Aggr(Rank(Sum({&lt;Branch_ID=&gt;} Sale)),Branch_ID)</P></BODY></HTML> Wed, 15 Jun 2016 05:57:28 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/1117391#M368732 MayilVahanan 2016-06-15T05:57:28Z