Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
satish25
Contributor III
Contributor III

Top 10%, 20% records as per rank for Measure

Hello Everyone,

I want to find the top 10%, 20% and so on Records in Qlik Sense.

Suppose I have 30 Records In a File.

  •      When I Select top 10%, the top 3 records with the highest value of Measure should appear.
  •      When I Select top 20%, the top 6 records with the highest value of Measure should appear.

And so on.

So wanted to know how to utilize the "Rank" function to achieve the given result.

Dimension: Person.

Measure: Sales.


Thanks in advance.

0 Replies