QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
New Contributor II

Customer Classification

Hi Gurus

 Cust 1 58,095.80 Cust 2 54,890.00 Cust 3 51,373.60 Cust 4 45,079.00 Cust 5 30,854.00 Cust 6 30,541.40 Cust 7 29,237.40 Cust 8 28,668.20 Cust 9 23,280.20 Cust 10 21,113.30

Base  on above raw data, how am I classify the customer class base on the below criteria

Class A (yellow)= Total of customer x 20 %

In the above, ie : 10 x 0.20 = First 2 records

Class B (Green) = Total of customer x 50 %

In the above, ie : 10 x 0.50 = Subsequent 5 records

Class C (grey)= Total of customer x 20 %

In the above, ie : 10 x 0.20 = subsequesnt 2 records

Class D (red)= Total of customer x 10 %

In the above, ie : 10 x 0.10 = subsequesnt 1 records

I have made to understand by using Aggr can do that ? But how exactly ?

Tags (2)
6 Replies
Contributor II

Re: Customer Classification

Hello,

What you need is ABC Analysis.

Have a look here:

Recipe for an ABC Analysis

Recipe for a Pareto Analysis – Revisited

New Contributor II

Re: Customer Classification

Thank you so much  Eliza ! Your reply with the 2 links/ blog given has helped me to understand/ solve my problem.

Take Care !

Contributor II

Re: Customer Classification

Would you mind closing this thread.

Have a nice day!

New Contributor II

Re: Customer Classification

Errmmm..how am i suppose to close the thread ? I wish to remain the thread to help the others

Contributor II

Re: Customer Classification

Esteemed Contributor