Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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:

RankSum
53147135
5495657
5516765
560
560
560
560
560
560
560
560
560
560
3 Replies
Not applicable
Author

same happens to me with v 11.0.11440.0 SR2 64bit

Please fix this bug

Not applicable
Author

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))

Not applicable
Author

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