Hello, I have found very useful documents and discussions about Pareto Analysis (ABC analysis) in the community.
However, I need to build the "Pareto Class" at script level (my need is to build a Pareto analysis for customers), because I need to refer to calculated Class everywhere, not only in the chart showing the analysis.
Anyone knows where to find an example of script calculating the Pareto Class I can study?
Any suggestion is highly appreciated, thanks!
Did you succeed creating the Pareto Class Analysis at script level? I'm working on the improvement of performance of my QlikView Document which uses a script with a Pareto Class Analysis.
Please let me know how you cope with it.
refer to my previous post (two way derived abc analysis available. 1) using pareto method 2) sortable aggregation method (this is feature available from Qv 12 and above version.
another way using sortable aggration method via front end (simplest way to have cal.dimension)
Hello Juan Camilo,
unfortunately I did not make any progress there, I am still using a workaround: I built Pareto charts as perfecty explained in this Tutorial by Henric Cronström: Recipe for a Pareto Analysis
Then I export charts in Excel, and import them again in my Qlik Application.
Sorry, I can't help.
Finally I got it. This is how I'm generating my ABC Analisys at Script level.
,Sum(Consumo) as ConsumoAcumulado
Group by CodigoInsumo, PeriodKey;
,Sum(Consumo) as GranTotal
Group by PeriodKey;
,RangeSum(ConsumoAcumulado, Peek('Acumulado') * 1) AS Acumulado
Order by ConsumoAcumulado Desc;
,Acumulado / GranTotal as Inclusive
,If(Inclusive <= 0.85, 'A', If(Inclusive <= 0.95, 'B', 'C')) AS ParetoClass
Any suggestion will be well received. !