topic Re: Calculate the Rank in QlikView https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328498#M842345 <HTML><HEAD></HEAD><BODY><P>Hello Prabhas,</P><P></P><P>Refer attached sample application.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Thu, 27 Apr 2017 04:49:02 GMT rahulpawarb 2017-04-27T04:49:02Z Calculate the Rank https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328494#M842341 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I have 5 years data in my dashboard, now i want rank for the multiple years.<BR />Ex: i have years like&nbsp; 2010,2011,2012,2013,2014&nbsp; and their sales 10,20,30,40,50, resp.</P><P></P><P>now if click on 2014,2013 then i want get the rank for those years.how to get it?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328494#M842341 prabhas277 2020-11-25T16:16:04Z Re: Calculate the Rank https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328495#M842342 <HTML><HEAD></HEAD><BODY><P>Is this you are expecting?</P><P></P><P>Without selection</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161402_Capture.PNG" style="height: auto;" /></P><P>With Selection</P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/161403_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 27 Apr 2017 04:33:51 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328495#M842342 Anil_Babu_Samineni 2017-04-27T04:33:51Z Re: Calculate the Rank https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328496#M842343 <HTML><HEAD></HEAD><BODY><P>Thanks for reply</P><P></P><P>Can you please share the expression?</P></BODY></HTML> Thu, 27 Apr 2017 04:38:12 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328496#M842343 prabhas277 2017-04-27T04:38:12Z Re: Calculate the Rank https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328497#M842344 <HTML><HEAD></HEAD><BODY><P>Create straight table</P><P>Dimension is <STRONG>Year</STRONG></P><P>Expressions are </P><P><STRONG>1) Sum(Sales) </STRONG></P><P><STRONG>2) Rank(Sales)</STRONG></P><P></P><P>Note: For filter you may take Year as List box</P></BODY></HTML> Thu, 27 Apr 2017 04:42:12 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328497#M842344 Anil_Babu_Samineni 2017-04-27T04:42:12Z Re: Calculate the Rank https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328498#M842345 <HTML><HEAD></HEAD><BODY><P>Hello Prabhas,</P><P></P><P>Refer attached sample application.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Thu, 27 Apr 2017 04:49:02 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Rank/m-p/1328498#M842345 rahulpawarb 2017-04-27T04:49:02Z