topic Rank in Reverse Order in QlikView https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553832#M550231 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P>I created a Staright table with few dimensions and some expressions including 'Rank()'.</P><P>Its working fine .</P><P></P><P>May I know how can I get Ranking in Reverse order for Descending Sorted Values.</P><P></P><P></P><P>Thanks in advance.</P><P></P><P>Best Regards,</P><P>Susvith</P></BODY></HTML> Tue, 10 Dec 2013 11:49:24 GMT 2013-12-10T11:49:24Z Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553832#M550231 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P>I created a Staright table with few dimensions and some expressions including 'Rank()'.</P><P>Its working fine .</P><P></P><P>May I know how can I get Ranking in Reverse order for Descending Sorted Values.</P><P></P><P></P><P>Thanks in advance.</P><P></P><P>Best Regards,</P><P>Susvith</P></BODY></HTML> Tue, 10 Dec 2013 11:49:24 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553832#M550231 2013-12-10T11:49:24Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553833#M550232 <HTML><HEAD></HEAD><BODY><P>Rank(-sum(yourvalue))</P></BODY></HTML> Tue, 10 Dec 2013 11:50:08 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553833#M550232 Clever_Anjos 2013-12-10T11:50:08Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553834#M550233 <HTML><HEAD></HEAD><BODY><P>I think that </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Rank<SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #0000ff;">TOTAL</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;"> - </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #0000ff;">if</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;">( // the rest of your expression</SPAN></P></BODY></HTML> Tue, 10 Dec 2013 12:01:53 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553834#M550233 Clever_Anjos 2013-12-10T12:01:53Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553835#M550234 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use a different approach.</P><P>like below:</P><P></P><P>=Rank(- Column(5)),</P><P>use your column number, count expressions to count column.</P><P></P><P>Hope it helps...</P></BODY></HTML> Tue, 10 Dec 2013 12:06:55 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553835#M550234 israrkhan 2013-12-10T12:06:55Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553836#M550235 <HTML><HEAD></HEAD><BODY><P>try this <SPAN style="color: #800000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 11px;">EX_SHIPPING_SALES_AMOUNT</SPAN> * -1</P></BODY></HTML> Tue, 10 Dec 2013 12:06:56 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553836#M550235 2013-12-10T12:06:56Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553837#M550236 <HTML><HEAD></HEAD><BODY><P>Thanks for reply ..</P><P></P><P>But still its not working</P></BODY></HTML> Tue, 10 Dec 2013 12:07:51 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553837#M550236 2013-12-10T12:07:51Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553838#M550237 <HTML><HEAD></HEAD><BODY><P>Thanks for all your replies...</P><P></P><P></P><P>But nothing is working in my case...</P><P></P><P>Please let me know if u have any other ideas.</P><P></P><P>Best Regards,</P><P>Susvith</P></BODY></HTML> Tue, 10 Dec 2013 12:23:02 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553838#M550237 2013-12-10T12:23:02Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553839#M550238 <HTML><HEAD></HEAD><BODY><P>You can attach an app to get right solution</P></BODY></HTML> Tue, 10 Dec 2013 12:27:07 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553839#M550238 2013-12-10T12:27:07Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553840#M550239 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try According to this Attachment.</P></BODY></HTML> Tue, 10 Dec 2013 12:32:13 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553840#M550239 2013-12-10T12:32:13Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553841#M550240 <HTML><HEAD></HEAD><BODY><P>I cant find any attachment here. Can you please attach the file</P><P></P><P>THanks</P></BODY></HTML> Tue, 10 Dec 2013 12:34:23 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553841#M550240 2013-12-10T12:34:23Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553842#M550241 <HTML><HEAD></HEAD><BODY><P>Thanks all ...</P><P></P><P></P><P>Every ones answer is working .&nbsp; I did changes in sorting ...</P><P></P><P>Regards,</P><P>Susvith</P></BODY></HTML> Tue, 10 Dec 2013 12:50:26 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553842#M550241 2013-12-10T12:50:26Z Re: Rank in Reverse Order https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553843#M550242 <HTML><HEAD></HEAD><BODY><P>As in <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/VISHWARANJAN">VISHWARANJAN</A> attached file</STRONG></P><P></P><P>You could also try</P><P></P><P><IMG alt="2013-12-10_1327.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50255_2013-12-10_1327.png" /></P></BODY></HTML> Tue, 10 Dec 2013 13:30:19 GMT https://community.qlik.com/t5/QlikView/Rank-in-Reverse-Order/m-p/553843#M550242 rustyfishbones 2013-12-10T13:30:19Z