topic Re: Pivot table- Rank in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Rank/m-p/1240787#M866255 <HTML><HEAD></HEAD><BODY><P> Rank( Count (DISTINCT</P><P></P><P></P><P>Just a thought , use this in expression. </P></BODY></HTML> Fri, 09 Dec 2016 20:50:19 GMT everest226 2016-12-09T20:50:19Z Pivot table- Rank https://community.qlik.com/t5/QlikView/Pivot-table-Rank/m-p/1240786#M866254 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table and I have sorted it according to the total points(descending).</P><P><SPAN style="font-size: 10pt;">Expression for total points is attached. I've used the same expression to sort the table.</SPAN></P><P><IMG __jive_id="146209" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146209_Capture.PNG" style="height: auto;" /></P><P></P><P><SPAN style="font-size: 10pt;">I&nbsp; want to add a rank to the teams depending on the total points (highest point will be rank 1). How can I achieve that? I want the rank function to work even when the table is expanded.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><IMG __jive_id="146229" alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/146229_Capture.PNG" style="height: auto;" /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Rank/m-p/1240786#M866254 Anonymous 2020-11-25T16:16:04Z Re: Pivot table- Rank https://community.qlik.com/t5/QlikView/Pivot-table-Rank/m-p/1240787#M866255 <HTML><HEAD></HEAD><BODY><P> Rank( Count (DISTINCT</P><P></P><P></P><P>Just a thought , use this in expression. </P></BODY></HTML> Fri, 09 Dec 2016 20:50:19 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Rank/m-p/1240787#M866255 everest226 2016-12-09T20:50:19Z Re: Pivot table- Rank https://community.qlik.com/t5/QlikView/Pivot-table-Rank/m-p/1240788#M866256 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Rank( Sum(total &lt;Team&gt;&nbsp; [your points expression]))</SPAN></P></BODY></HTML> Sat, 10 Dec 2016 11:33:46 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Rank/m-p/1240788#M866256 Clever_Anjos 2016-12-10T11:33:46Z