topic Rank in Straight table by specific dimension in QlikView https://community.qlik.com/t5/QlikView/Rank-in-Straight-table-by-specific-dimension/m-p/406027#M1163256 <HTML><HEAD></HEAD><BODY><P>I have a straight table that has multiple dimensions, but I want to rank on a specific dimension, how can I do this.&nbsp; Here is my current definition</P><P></P><P>=</P><P><SPAN style="color: #0000ff; font-size: 8pt;">RANk</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">)* </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AVG</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">NumberOfItemInSet</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #800000; font-size: 8pt;">IntroDateDif</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">That works but I need it to rank on just the one dimension field names "Item".</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thanks in Advance</SPAN></P></BODY></HTML> Tue, 06 Nov 2012 14:29:14 GMT 2012-11-06T14:29:14Z Rank in Straight table by specific dimension https://community.qlik.com/t5/QlikView/Rank-in-Straight-table-by-specific-dimension/m-p/406027#M1163256 <HTML><HEAD></HEAD><BODY><P>I have a straight table that has multiple dimensions, but I want to rank on a specific dimension, how can I do this.&nbsp; Here is my current definition</P><P></P><P>=</P><P><SPAN style="color: #0000ff; font-size: 8pt;">RANk</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">)* </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AVG</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">NumberOfItemInSet</SPAN><SPAN style="font-size: 8pt;">))/</SPAN><SPAN style="color: #800000; font-size: 8pt;">IntroDateDif</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">That works but I need it to rank on just the one dimension field names "Item".</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thanks in Advance</SPAN></P></BODY></HTML> Tue, 06 Nov 2012 14:29:14 GMT https://community.qlik.com/t5/QlikView/Rank-in-Straight-table-by-specific-dimension/m-p/406027#M1163256 2012-11-06T14:29:14Z Re: Rank in Straight table by specific dimension https://community.qlik.com/t5/QlikView/Rank-in-Straight-table-by-specific-dimension/m-p/406028#M1163257 <HTML><HEAD></HEAD><BODY><P>Hi <SPAN style="font-size: 10pt;">ljames77</SPAN></P><P></P><P>I think you can use the TOTAL aggregation, but ignore your desired fieldname. <EM><SPAN class="Bold"><SPAN style="background-color: #3399ff; color: #ffffff;">rank</SPAN>(</SPAN><SPAN class="Italic">[ <SPAN class="Bold">total</SPAN> ] expression [ , mode [, format ] ]</SPAN><SPAN class="Bold">)</SPAN></EM></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13522124960846621" jivemacro_uid="_13522124960846621"><P><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #0000ff;">RANk</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">(TOTAL &lt;<SPAN style="color: #737373; font-family: Arial; font-size: 11px; background-color: #ffffff;">Item</SPAN>&gt; (</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #0000ff;">sum</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">(</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #800000;">Quantity</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">)* </SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #0000ff;">AVG</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">(</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #800000;">NumberOfItemInSet</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">))/</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #800000;">IntroDateDif</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">)</SPAN></P><P></P></PRE><P></P><P>Best regards</P><P><A href="https://community.qlik.com/qlik-users/100292">Vegar Lie Arntsen</A></P><P><EM>QlikView consultant at </EM><A href="http://bit.ly/PoSwU2">egbs consulting ab</A></P><P><EM>Blog (in Swedish):</EM> <A href="http://bit.ly/UkXdvt">bi-effekten.se</A></P></BODY></HTML> Tue, 06 Nov 2012 14:37:30 GMT https://community.qlik.com/t5/QlikView/Rank-in-Straight-table-by-specific-dimension/m-p/406028#M1163257 Vegar 2012-11-06T14:37:30Z