Rank() mode=4 is NOT returning a unique value

[#1]

When using rank() with mode=4 not getting distinct numeric values as documentation says I should. The last 10 sum() values are all 0, but the ranking value is the same at 56. NOT 56, 57, 58, etc. as I need and I thought MODE=4 would do as described in the documentation.

rank(sum( TotalClicks ), 4, 1)

sum( TotalClicks)

Bottom part of the table:

Rank	Sum
53	147135
54	95657
55	16765
56	0
56	0
56	0
56	0
56	0
56	0
56	0
56	0
56	0
56	0

[#2]

same happens to me with v 11.0.11440.0 SR2 64bit

Please fix this bug

[#3]

I came across this post while searching. It seems like a Num() function is needed around the Rank to get Mode=4 to work.

Num(rank(sum( TotalClicks ), 4, 1))

[#4]

Hi @jims1958,

If you would like to use mode parameter you have to use num function, see attached pic, and this post.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Examples%20of%20Chart%20Ranking%...

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Daniel