Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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