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.