topic Rank For multiple Years in QlikView https://community.qlik.com/t5/QlikView/Rank-For-multiple-Years/m-p/1333117#M840763 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Please find the below xlsx file which contains the data for the 3 years.</P><P></P><P>now for that data i want rank for the multiple years like 2015,2016 for Specific&nbsp; field a.</P><P></P><P>explanation::</P><P>If i click on&nbsp; 2015 ,2016 years&nbsp; for product a then i want rank for both years..</P><P></P><P>how to get the rank for those years?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT prabhas277 2020-11-25T16:16:04Z Rank For multiple Years https://community.qlik.com/t5/QlikView/Rank-For-multiple-Years/m-p/1333117#M840763 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Please find the below xlsx file which contains the data for the 3 years.</P><P></P><P>now for that data i want rank for the multiple years like 2015,2016 for Specific&nbsp; field a.</P><P></P><P>explanation::</P><P>If i click on&nbsp; 2015 ,2016 years&nbsp; for product a then i want rank for both years..</P><P></P><P>how to get the rank for those years?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rank-For-multiple-Years/m-p/1333117#M840763 prabhas277 2020-11-25T16:16:04Z Re: Rank For multiple Years https://community.qlik.com/t5/QlikView/Rank-For-multiple-Years/m-p/1333118#M840764 <HTML><HEAD></HEAD><BODY><P>Maybe use a table chart with dimensions year, product</P><P></P><P>Expression</P><P>=Sum(sales)</P><P></P><P>Rank in year</P><P>=Rank(Sum(sales))</P><P></P><P>Overall rank</P><P>=Rank(TOTAL Sum(sales))</P></BODY></HTML> Thu, 27 Apr 2017 15:04:34 GMT https://community.qlik.com/t5/QlikView/Rank-For-multiple-Years/m-p/1333118#M840764 swuehl 2017-04-27T15:04:34Z Re: Rank For multiple Years https://community.qlik.com/t5/QlikView/Rank-For-multiple-Years/m-p/1333119#M840765 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161496_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 27 Apr 2017 15:08:40 GMT https://community.qlik.com/t5/QlikView/Rank-For-multiple-Years/m-p/1333119#M840765 sunny_talwar 2017-04-27T15:08:40Z