topic Re: Customer Classification in QlikView

Customer Classification

limfungkeat — Tue, 25 Apr 2017 04:06:26 GMT

Hi Gurus

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 ?

ElizaF — Tue, 25 Apr 2017 05:28:25 GMT

Hello,

What you need is ABC Analysis.

Have a look here:

limfungkeat — Tue, 25 Apr 2017 07:27:13 GMT

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

Take Care !

ElizaF — Tue, 25 Apr 2017 07:49:27 GMT

I am glad it did help you.

Would you mind closing this thread.

Have a nice day!

limfungkeat — Tue, 25 Apr 2017 08:01:33 GMT

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

ElizaF — Tue, 25 Apr 2017 08:12:28 GMT

See below the link:

awhitfield — Tue, 25 Apr 2017 08:53:29 GMT

Here you go!

Andy