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!

      Regards,

      Davide