topic ABC analysis and pareto in QlikView

ABC analysis and pareto

Wed, 07 Aug 2013 09:58:01 GMT

Hello All,

I need help in ABC analysis and showing a chart. I have the ABC analysis, so far so good. On the right side I have a chart with a dynamic dimension

"number of customer in %". The lines for the limitation of A-class(80%) and B-class(95%) are fix.

Now I need the lines "in red". How much "number of customer in %" are in class-A and class-B and class-C.

What I also need are the same in text-boxes.

Can anybody help???

Re: ABC analysis and pareto

Gysbert_Wassenaar — Wed, 07 Aug 2013 11:08:05 GMT

As far as I know this can't be done with expressions only. See this discussion for example. If it's possible to do the calculations in the script, which is possible with your sample data, it becomes quite simple. See attached qvw.

Re: ABC analysis and pareto

Fri, 09 Aug 2013 05:40:34 GMT

Hi Gysbert,

thanks for it. That ist the right way but I need it with expressions cause the user

will select for example customergroups before the abc analysis will done