Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
somenathroy
Creator III
Creator III

Rank within set analysis not working with proper limit

Hi All,

I am using Qlik Sense jun-2017 server version.

My objective is to get total sales values of top 10 users out of Top 20 users set by Dimension Limitation(Fixed Number = 20).

Have written the expression as:

SUM(total{<contact_id = {"=Rank(SUM(sales),4)<=10"}>}sales)

This is resulting sales value upto top 9 users. But if change the expression to

SUM(total{<contact_id = {"=Rank(SUM(sales),4)<12"}>}sales) giving the correct result.

Can anyone please explain why limit of the Rank is not working properly within set ?

Please find the attached data for detail clarification.

Regards,

som

0 Replies