topic Rank(x,1) not working in QlikView https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235804#M87052 <HTML><HEAD></HEAD><BODY><P>Can you give us an example of the 'wrong' results? Steps to repro? your expected result?</P><P>We need more detail before we can help.</P></BODY></HTML> Wed, 28 Jul 2010 00:52:57 GMT 2010-07-28T00:52:57Z Rank(x,1) not working https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235803#M87051 <HTML><HEAD></HEAD><BODY><P>I'm trying to use rank to display the lowest values, but no matter what I use in the 2nd parameter, the result is the same. I'm using v9 sr3.</P></BODY></HTML> Wed, 28 Jul 2010 00:32:08 GMT https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235803#M87051 2010-07-28T00:32:08Z Rank(x,1) not working https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235804#M87052 <HTML><HEAD></HEAD><BODY><P>Can you give us an example of the 'wrong' results? Steps to repro? your expected result?</P><P>We need more detail before we can help.</P></BODY></HTML> Wed, 28 Jul 2010 00:52:57 GMT https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235804#M87052 2010-07-28T00:52:57Z Rank(x,1) not working https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235805#M87053 <HTML><HEAD></HEAD><BODY><P>The wrong result is that Rank(x,1)=1 is the highest value, not the lowest.</P><P></P><P>I'll upload a QVW to reproduce the error.</P></BODY></HTML> Wed, 28 Jul 2010 00:59:36 GMT https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235805#M87053 2010-07-28T00:59:36Z Rank(x,1) not working https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235806#M87054 <HTML><HEAD></HEAD><BODY><P>In fact, the rank function return a dual format number.</P><P>To see the result of changing the 2nd parameter, you need to use =num(rank(var,1)</P></BODY></HTML> Fri, 08 Apr 2011 19:26:14 GMT https://community.qlik.com/t5/QlikView/Rank-x-1-not-working/m-p/235806#M87054 2011-04-08T19:26:14Z