Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satish25
New 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.

Community Browser