topic Re: How to get Sorting in Rank? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378026#M511775 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>try this,</P><P></P><P>try same expression <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=rank(Rank)&nbsp; for first dimension of pivot table.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><IMG alt="Rank.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186376_Rank.png" style="height: 349px; width: 620px;" /></SPAN></P></BODY></HTML> Mon, 11 Dec 2017 09:37:11 GMT ashwinishinde 2017-12-11T09:37:11Z How to get Sorting in Rank? https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378023#M511772 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have Rank Id 's in Calculated dimension in Pivot table .</P><P></P><P>How to get Rank wise sorting in Dimension level</P><P></P><P>Rank:</P><P>12</P><P>32</P><P>45</P><P>1</P><P>344</P><P>excapted out put is</P><P></P><P>Rank</P><P>1</P><P>12</P><P>32</P><P>45</P><P>344</P></BODY></HTML> Mon, 11 Dec 2017 08:48:12 GMT https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378023#M511772 Anonymous 2017-12-11T08:48:12Z Re: How to get Sorting in Rank? https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378024#M511773 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>try this,</P><P></P><P>Properties --&gt;Sort --&gt; Expression --&gt; =rank(Rank) </P></BODY></HTML> Mon, 11 Dec 2017 09:19:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378024#M511773 ashwinishinde 2017-12-11T09:19:39Z Re: How to get Sorting in Rank? https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378025#M511774 <HTML><HEAD></HEAD><BODY><P>HI Shinde,</P><P></P><P>But here Rank is calculated dimension.</P></BODY></HTML> Mon, 11 Dec 2017 09:23:36 GMT https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378025#M511774 Anonymous 2017-12-11T09:23:36Z Re: How to get Sorting in Rank? https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378026#M511775 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>try this,</P><P></P><P>try same expression <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=rank(Rank)&nbsp; for first dimension of pivot table.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><IMG alt="Rank.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186376_Rank.png" style="height: 349px; width: 620px;" /></SPAN></P></BODY></HTML> Mon, 11 Dec 2017 09:37:11 GMT https://community.qlik.com/t5/QlikView/How-to-get-Sorting-in-Rank/m-p/1378026#M511775 ashwinishinde 2017-12-11T09:37:11Z