2 Replies Latest reply: Aug 19, 2010 11:19 AM by Henry Noh RSS

    How to FORCE A RANK function?

    Henry Noh

      I have a table with Client and SalesAmt. I want to have a column that assigns a distinct numerical rank to every client.

      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?

       

      Thanks in advance.