topic Re: Need Help Using Rank in a Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360669#M133954 <HTML><HEAD></HEAD><BODY><P>Hi Stefan,</P><P></P><P>Can you please take a look at my post:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/1175515/edit?draftID=1040661" style="font-size: 10pt;" title="https://community.qlik.com/message/1175515/edit?draftID=1040661">https://community.qlik.com/message/1175515/edit?draftID=1040661</A></P></BODY></HTML> Sat, 10 Dec 2016 23:36:32 GMT Anonymous 2016-12-10T23:36:32Z Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360662#M133947 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am really struggling to figure out how to use the Rank function in a pivot table.&nbsp; All previous examples I've seen do not have a horizontal dimension and I've tried adding in a calculated dimension as well as an expression but to no avail.&nbsp; All I want is an additional column with 1 - 10 in it but this seems to be a real struggle.&nbsp; </P><P></P><P>Can anyone help?</P></BODY></HTML> Fri, 20 Jul 2012 13:19:06 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360662#M133947 2012-07-20T13:19:06Z Re: Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360663#M133948 <HTML><HEAD></HEAD><BODY><P>Example of what I'm trying to get attached ... </P></BODY></HTML> Fri, 20 Jul 2012 13:24:00 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360663#M133948 2012-07-20T13:24:00Z Re: Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360664#M133949 <HTML><HEAD></HEAD><BODY><P>add an expression column with <STRONG>=rowno()</STRONG></P></BODY></HTML> Fri, 20 Jul 2012 13:33:19 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360664#M133949 2012-07-20T13:33:19Z Re: Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360665#M133950 <HTML><HEAD></HEAD><BODY><P>What about using a calculated dimension like</P><P></P><P><EM>=aggr(rank(sum(Amount))&amp;' - '&amp;&nbsp; Client_Group,Client_Group)</EM></P><P></P><P>instead of Client_Group?</P><P></P><P>edit:</P><P>Or an additional calculated dimension</P><P><EM>=aggr(rank(sum(Amount)),Client_Group)</EM></P><P></P><P>together with your existing ones?<EM><BR /></EM></P></BODY></HTML> Fri, 20 Jul 2012 13:33:46 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360665#M133950 swuehl 2012-07-20T13:33:46Z Re: Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360666#M133951 <HTML><HEAD></HEAD><BODY><P>Hi Pari Pari - I tried rowno() both as a calculated dimension and an expression but couldn't get it to work.</P><P></P><P>If you've managed it can you attach an example?</P><P></P><P>Thanks,</P><P>Emma</P></BODY></HTML> Fri, 20 Jul 2012 13:36:40 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360666#M133951 2012-07-20T13:36:40Z Re: Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360667#M133952 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>Many thanks - both answers work really well and my end user has a big smile on her face! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Cheers,</P><P></P><P>Emma</P></BODY></HTML> Fri, 20 Jul 2012 14:21:39 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360667#M133952 2012-07-20T14:21:39Z Re: Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360668#M133953 <HTML><HEAD></HEAD><BODY><P>Your welcome.</P><P></P><P>The CON to this solution is that we are using a calculated dimension, which might not perform very well on large data. But If your end user keeps on smiling ...</P><P></P><P>Another possibility that came to my mind is to print some static numbers (text objects, straight table) next to your pivot table. Not really nice, but with nice performance <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P></P><P>In a straight table, you could probably work out a solution using rowno(), as suggested above.</P><P></P><P>Have a nice day,</P><P>Stefan</P></BODY></HTML> Fri, 20 Jul 2012 14:25:47 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360668#M133953 swuehl 2012-07-20T14:25:47Z Re: Need Help Using Rank in a Pivot Table https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360669#M133954 <HTML><HEAD></HEAD><BODY><P>Hi Stefan,</P><P></P><P>Can you please take a look at my post:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/1175515/edit?draftID=1040661" style="font-size: 10pt;" title="https://community.qlik.com/message/1175515/edit?draftID=1040661">https://community.qlik.com/message/1175515/edit?draftID=1040661</A></P></BODY></HTML> Sat, 10 Dec 2016 23:36:32 GMT https://community.qlik.com/t5/QlikView/Need-Help-Using-Rank-in-a-Pivot-Table/m-p/360669#M133954 Anonymous 2016-12-10T23:36:32Z