6 Replies Latest reply: Jan 18, 2017 9:05 PM by Wenjun Wu RSS

    How to count number of customers fall in top 5%?

    Wenjun Wu

      Hi,

       

      I am able to use QlikSense bar chart to plot by business areas, top 5% highest average sales by customer accounts.

       

      AreasCustomer AccountsTop 5% Average Sales
      Ac0000199999
      Ac000029999
      Ac00003999
      Ac0000499
      Ac000059
      Aothers1
      Bc111190
      Bothers10

      Others are those fall outside top 5%.

       

      I need a column to count number of customers fall in top 5% by area, how to count ?

      AreaNo. of customers
      A5
      B1

       

      Thank you.