topic How to FORCE A RANK function? in QlikView https://community.qlik.com/t5/QlikView/How-to-FORCE-A-RANK-function/m-p/272230#M1202099 <HTML><HEAD></HEAD><BODY><P>Rank(myColumn,0,1) should do the trick. Check the Rank() documentation for specifics.</P></BODY></HTML> Thu, 19 Aug 2010 15:05:39 GMT Or 2010-08-19T15:05:39Z How to FORCE A RANK function? https://community.qlik.com/t5/QlikView/How-to-FORCE-A-RANK-function/m-p/272229#M1202097 <HTML><HEAD></HEAD><BODY><P>I have a table with Client and SalesAmt. I want to have a column that assigns a distinct numerical rank to every client.</P><P>When I use the rank function(mode4), I'm still getting the bucketed rank (e.g. 12-15) for those clients with exact same sales. I'd like qlik to force rank the ties to assign distinct rank to each client. Is this possible?</P><P></P><P>Thanks in advance.</P><P></P><P></P></BODY></HTML> Thu, 19 Aug 2010 15:03:18 GMT https://community.qlik.com/t5/QlikView/How-to-FORCE-A-RANK-function/m-p/272229#M1202097 2010-08-19T15:03:18Z How to FORCE A RANK function? https://community.qlik.com/t5/QlikView/How-to-FORCE-A-RANK-function/m-p/272230#M1202099 <HTML><HEAD></HEAD><BODY><P>Rank(myColumn,0,1) should do the trick. Check the Rank() documentation for specifics.</P></BODY></HTML> Thu, 19 Aug 2010 15:05:39 GMT https://community.qlik.com/t5/QlikView/How-to-FORCE-A-RANK-function/m-p/272230#M1202099 Or 2010-08-19T15:05:39Z How to FORCE A RANK function? https://community.qlik.com/t5/QlikView/How-to-FORCE-A-RANK-function/m-p/272231#M1202102 <HTML><HEAD></HEAD><BODY><P>Thank you! This worked great.</P></BODY></HTML> Thu, 19 Aug 2010 15:19:01 GMT https://community.qlik.com/t5/QlikView/How-to-FORCE-A-RANK-function/m-p/272231#M1202102 2010-08-19T15:19:01Z