Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
limfungkeat
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
ElizaF
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

limfungkeat
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 !

ElizaF
Contributor II

Re: Customer Classification

I am glad it did help you.

Would you mind closing this thread.

Have a nice day!

limfungkeat
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

ElizaF
Contributor II

Re: Customer Classification

awhitfield
Esteemed Contributor

Re: Customer Classification

Community Browser