This content has been marked as final. Show 2 replies
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.