Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
limfungkeat
Contributor III
Contributor III

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 ?

6 Replies
ElizaF
Creator II
Creator II

Hello,


What you need is ABC Analysis.

Have a look here:

Recipe for an ABC Analysis

Recipe for a Pareto Analysis – Revisited

limfungkeat
Contributor III
Contributor III
Author

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

Take Care !

ElizaF
Creator II
Creator II

I am glad it did help you.

Would you mind closing this thread.

Have a nice day!

limfungkeat
Contributor III
Contributor III
Author

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