0 Replies Latest reply: Aug 1, 2018 2:22 PM by satish rathod RSS

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

    satish rathod

      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.