4 Replies Latest reply: Jul 13, 2017 12:00 PM by Mark Jacobs RSS

    Count of products that generate 50% of sales as a KPI in Qlik Sense

    Mark Jacobs

      Hi,

       

      In Qlik Sense, would you know of a way to generate the number of distinct products that make up 50% of all sales? I do not want to put this in a table; rather I would like to display it as a KPI value. I would also like to include in the KPI the percentage of products that make up this 50%. Actually, the ultimate KPI would show something like:

       

      50% of sales are driven by 240 (8%) of our products.

       

      In this case, there are 3000 distinct products of which 240 (8%) make up 50% of sales.

       

      Thank you for your help!!!

      Mark