5 Replies Latest reply: Dec 8, 2017 12:50 PM by Davide Purpura RSS

    QlikSense Distinct Count of Items that Makes 80% of Total Sales

    Davide Purpura

      Hi All,

      Is there a way, with a formula, to get the number of items (count distinct of a field) that makes the 80% of sales (sum of sales field ordered top-down)?

      For example, if I have:


      Product CodeSales
      Product 01500
      Product 02200
      Product 03300



      500 (Product 01) + 300 (Product 03) = 800, that is the 80% of total Sales field, this means that result is 2 (count distinct of Product 01 and Product 03).


      By searching in the community I've not found anything to get the result...


      Many thanks in advance!