topic Re: Top two rank over two dimensions in QlikView https://community.qlik.com/t5/QlikView/Top-two-rank-over-two-dimensions/m-p/1000885#M340222 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>Look the Rank() function on the help file</P><P></P><P>Hope it helps</P><P></P><P>Joaquín</P></BODY></HTML> Fri, 30 Oct 2015 15:36:07 GMT Joaquin_Lazaro 2015-10-30T15:36:07Z Top two rank over two dimensions https://community.qlik.com/t5/QlikView/Top-two-rank-over-two-dimensions/m-p/1000884#M340221 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a requirement where I have to show top two ranks based on two dimensions. For example:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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>Area</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sum(Subscribers)</STRONG></TH></TR><TR><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1800</TD></TR><TR><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1300</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1100</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1850</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1900</TD></TR></TBODY></TABLE><P></P><P>I have Year and Area as dimensions, while Sum(Subscribers) in an expression. Required result:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><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>Area</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sum(Subscribers)</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Rank</TH></TR><TR><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1800</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2011</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1300</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1900</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">202</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1850</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE><P></P><P></P><P>So, how to find top 'n' ranking based on more than one dimension?</P><P></P><P>Thank you!!</P></BODY></HTML> Fri, 30 Oct 2015 15:31:49 GMT https://community.qlik.com/t5/QlikView/Top-two-rank-over-two-dimensions/m-p/1000884#M340221 2015-10-30T15:31:49Z Re: Top two rank over two dimensions https://community.qlik.com/t5/QlikView/Top-two-rank-over-two-dimensions/m-p/1000885#M340222 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>Look the Rank() function on the help file</P><P></P><P>Hope it helps</P><P></P><P>Joaquín</P></BODY></HTML> Fri, 30 Oct 2015 15:36:07 GMT https://community.qlik.com/t5/QlikView/Top-two-rank-over-two-dimensions/m-p/1000885#M340222 Joaquin_Lazaro 2015-10-30T15:36:07Z Re: Top two rank over two dimensions https://community.qlik.com/t5/QlikView/Top-two-rank-over-two-dimensions/m-p/1000886#M340223 <HTML><HEAD></HEAD><BODY><P>May be a calculated dimension:</P><P></P><P><STRONG>=If(Aggr(Rank([sum(Subscribers)]) &lt;= 2, Year, Area), Area)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/103624_Capture.PNG" style="height: 125px; width: 620px;" /></P></BODY></HTML> Fri, 30 Oct 2015 15:36:17 GMT https://community.qlik.com/t5/QlikView/Top-two-rank-over-two-dimensions/m-p/1000886#M340223 sunny_talwar 2015-10-30T15:36:17Z