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

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

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.

• ###### Re: How to count number of customers fall in top 5%?

What is the base data?

• ###### Re: How to count number of customers fall in top 5%?

Do you mean the very raw data?

They are individual monthly sales amount.

e.g. 4 months sales per customer.

Customer Sept Oct Nov Dec    Avg

c0001         15     10   10   15   12.5

Top 5 % based on Avg sales.

• ###### Re: How to count number of customers fall in top 5%?

Please provide proper sample data to work...

• ###### Re: How to count number of customers fall in top 5%?

Hi Manish,

Please use the dummy dataset attached.

Hope you got my question above.

Thanks alot!

• ###### Re: How to count number of customers fall in top 5%?

No..

If you can explain what exactly you want.. Also based on the data, can you provide the output table also?

• ###### Re: How to count number of customers fall in top 5%?

I want to count for each area,

How many customers are in top 5% based on their 4 months' sales average.

After thinking about it, actually am I right to say that If I get the 5% of the customer population per area, is equal to the population in top 5% per area?

If it is true, then I will just use 0.05 * count([Customer Accounts]), then rounding it to a whole number.

Thanks!