topic Re: Ranking Calculation in QlikView in QlikView https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957799#M956804 <HTML><HEAD></HEAD><BODY><P>Thank you Swuehl, this works well</P></BODY></HTML> Sun, 08 Nov 2015 14:20:19 GMT Anonymous 2015-11-08T14:20:19Z Ranking Calculation in QlikView https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957797#M956802 <HTML><HEAD></HEAD><BODY><P>I have the following data in a straight table:</P><P></P><P><IMG alt="Screen Shot 2015-11-08 at 13.04.49.png" class="jive-image image-1" src="/legacyfs/online/104321_Screen Shot 2015-11-08 at 13.04.49.png" style="height: 244px; width: 620px;" /></P><P>I need to be able to calculate 2012 and 2013 rankings based on the '2012 Quantity' and '2013 Quantity'.&nbsp; How can this be accomplished in QlikView?&nbsp; Please see attached sample application.</P><P></P><P>Regards.</P></BODY></HTML> Sun, 08 Nov 2015 11:21:23 GMT https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957797#M956802 Anonymous 2015-11-08T11:21:23Z Re: Ranking Calculation in QlikView https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957798#M956803 <HTML><HEAD></HEAD><BODY><P>Maybe just use expressions like</P><P>=Rank(TOTAL Sum ({$&lt;Year={2012},Month=&gt;} QTY))</P></BODY></HTML> Sun, 08 Nov 2015 11:35:41 GMT https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957798#M956803 swuehl 2015-11-08T11:35:41Z Re: Ranking Calculation in QlikView https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957799#M956804 <HTML><HEAD></HEAD><BODY><P>Thank you Swuehl, this works well</P></BODY></HTML> Sun, 08 Nov 2015 14:20:19 GMT https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957799#M956804 Anonymous 2015-11-08T14:20:19Z Re: Ranking Calculation in QlikView https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957800#M956805 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Thank you Swuehl, This explains well on Rank Function</SPAN></P></BODY></HTML> Sun, 08 Nov 2015 14:33:24 GMT https://community.qlik.com/t5/QlikView/Ranking-Calculation-in-QlikView/m-p/957800#M956805 psankepalli 2015-11-08T14:33:24Z