topic Re: Pivot Table - Sort by Rank within Dimensions in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Sort-by-Rank-within-Dimensions/m-p/666049#M242384 <HTML><HEAD></HEAD><BODY><P>If the normal sorting didn't work you could try it with dual() for the dimension:</P><P></P><P>dual(Country, RankExpression)</P><P></P><P>Have a look on posts like: <A href="https://community.qlik.com/message/494964">Re: Sort on straight table using class function</A></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 12 Aug 2014 14:16:14 GMT marcus_sommer 2014-08-12T14:16:14Z Pivot Table - Sort by Rank within Dimensions https://community.qlik.com/t5/QlikView/Pivot-Table-Sort-by-Rank-within-Dimensions/m-p/666048#M242383 <HTML><HEAD></HEAD><BODY><P>I have a pivot table that I am trying to sort by rank. However, I am not able to sort by rank even when I add the rank expression to the sort expression.&nbsp; </P><P></P><P>Is there any way to sort in context rather than globally? Has there been any workarounds since the post: <A _jive_internal="true" href="https://community.qlik.com/ideas/1480" title="http://community.qlik.com/ideas/1480">http://community.qlik.com/ideas/1480</A> <SPAN style="font-size: 10pt; line-height: 1.5em;">?</SPAN></P><P><IMG alt="QV Sorting.png" class="jive-image" src="/legacyfs/online/64231_QV Sorting.png" style="width: 620px; height: 453px;" /></P></BODY></HTML> Tue, 12 Aug 2014 13:48:41 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Sort-by-Rank-within-Dimensions/m-p/666048#M242383 2014-08-12T13:48:41Z Re: Pivot Table - Sort by Rank within Dimensions https://community.qlik.com/t5/QlikView/Pivot-Table-Sort-by-Rank-within-Dimensions/m-p/666049#M242384 <HTML><HEAD></HEAD><BODY><P>If the normal sorting didn't work you could try it with dual() for the dimension:</P><P></P><P>dual(Country, RankExpression)</P><P></P><P>Have a look on posts like: <A href="https://community.qlik.com/message/494964">Re: Sort on straight table using class function</A></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 12 Aug 2014 14:16:14 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Sort-by-Rank-within-Dimensions/m-p/666049#M242384 marcus_sommer 2014-08-12T14:16:14Z