Discussion Board for collaboration on QlikView Layout & Visualizations.
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 ?
What you need is ABC Analysis.
Have a look here:
Recipe for an ABC Analysis
Recipe for a Pareto Analysis – Revisited
Thank you so much Eliza ! Your reply with the 2 links/ blog given has helped me to understand/ solve my problem.
Take Care !
I am glad it did help you.
Would you mind closing this thread.
Have a nice day!
Errmmm..how am i suppose to close the thread ? I wish to remain the thread to help the others
See below the link:
Its not about the answer, rather it’s about the question…
Here you go!
Qlik Community Tip: Marking Replies as Correct or Helpful