How to FORCE A RANK function?

[#1]

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.

[Or · Accepted solution]

Rank(myColumn,0,1) should do the trick. Check the Rank() documentation for specifics.

[#3]

Thank you! This worked great.