topic Re: Rank() mode=4 is NOT returning a unique value in QlikView

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

Mon, 30 Aug 2010 23:38:47 GMT

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

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

Mon, 28 Jan 2013 21:13:05 GMT

same happens to me with v 11.0.11440.0 SR2 64bit

Please fix this bug

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

Wed, 02 Apr 2014 18:50:05 GMT

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

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

Tue, 31 Jan 2017 19:06:18 GMT

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%20functions.htm

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