topic Re: Rank for multiple years in QlikView https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330503#M842154 <HTML><HEAD></HEAD><BODY><P>Maybe like this:</P><P></P><P>Sales :</P><P><IMG alt="Sales.jpg" class="jive-image image-1" height="179" src="https://community.qlik.com/legacyfs/online/161502_Sales.jpg" width="340" /></P><P></P><P>Rank:</P><P><IMG alt="Rank.JPG" class="jive-image image-2" height="180" src="https://community.qlik.com/legacyfs/online/161503_Rank.JPG" width="432" /></P><P><BR /> </P></BODY></HTML> Thu, 27 Apr 2017 15:51:36 GMT sergio0592 2017-04-27T15:51:36Z Rank for multiple years https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330501#M842152 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have 3 years (2015,2016,2017) data. Each year is having 3 fields like a,b,c like below table.</P><TABLE border="1" class="jiveBorder" height="249" style="border: 1px solid #000000; width: 253px; height: 229px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>2015</P></TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">2016</TD><TD style="padding: 2px;">40</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2016</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">2016</TD><TD style="padding: 2px;">55</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">2017</TD><TD style="padding: 2px;">70</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2017</TD><TD style="padding: 2px;">40</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">2017</TD><TD style="padding: 2px;">23</TD><TD style="padding: 2px;">c</TD></TR></TBODY></TABLE><P></P><P>I want to get rank for <STRONG>2015</STRONG> and <STRONG>2016</STRONG> for product<STRONG> a .</STRONG></P><P>How to write the expression for this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330501#M842152 2020-11-25T16:16:04Z Re: Rank for multiple years https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330502#M842153 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>you can refer below thread.</P><P></P><P><A href="https://community.qlik.com/thread/159148">How to use rank function?</A></P></BODY></HTML> Thu, 27 Apr 2017 15:39:02 GMT https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330502#M842153 shiveshsingh 2017-04-27T15:39:02Z Re: Rank for multiple years https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330503#M842154 <HTML><HEAD></HEAD><BODY><P>Maybe like this:</P><P></P><P>Sales :</P><P><IMG alt="Sales.jpg" class="jive-image image-1" height="179" src="https://community.qlik.com/legacyfs/online/161502_Sales.jpg" width="340" /></P><P></P><P>Rank:</P><P><IMG alt="Rank.JPG" class="jive-image image-2" height="180" src="https://community.qlik.com/legacyfs/online/161503_Rank.JPG" width="432" /></P><P><BR /> </P></BODY></HTML> Thu, 27 Apr 2017 15:51:36 GMT https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330503#M842154 sergio0592 2017-04-27T15:51:36Z Re: Rank for multiple years https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330504#M842155 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Did you found the answer to this issue?</P><P></P><P>Thanks,</P><P>-Vidya</P></BODY></HTML> Wed, 28 Feb 2018 00:27:47 GMT https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330504#M842155 vidyasagar159 2018-02-28T00:27:47Z Re: Rank for multiple years https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330505#M842156 <HTML><HEAD></HEAD><BODY><P>Year and Product as Dimension </P><P>Expression:</P><P>If(Product='a' and (Year=2015 or Year=2016),</P><P>VRank(TOTAL Sum(Sales),0,1))</P><P></P><P></P><P><IMG alt="Capture3.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194811_Capture3.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 28 Feb 2018 05:27:23 GMT https://community.qlik.com/t5/QlikView/Rank-for-multiple-years/m-p/1330505#M842156 jerryyang756 2018-02-28T05:27:23Z