Yet on Pareto Analysis

[ebrambilla]

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!

[martynlloyd]

Hi, I am also interested in building the  pareto analysis at script level, for performance reasons.

Best regards,

M.

[jcrincon]

Hi Emilio:

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.

[devarasu07]

Hi,

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.

ABC Analysis in Qlikview

Recipe for a Pareto Analysis – Revisited

Qlik Design Blog : Recipe for a Pareto Analysis | Qlik Community

another way using sortable aggration method via front end (simplest way to have cal.dimension)

The sortable Aggr function is finally here!

Thanks

Deva

[ebrambilla]

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.

Emilio

[jcrincon]

Hello Emilio:

Finally I got it. This is how I'm generating my ABC Analisys at Script level.

<code>

ABC_Paso1:

LOAD CodigoInsumo

,PeriodKey

,Sum(Consumo) as ConsumoAcumulado

Resident Temp_valores

Group by CodigoInsumo, PeriodKey;

Temp_Total:

LOAD

PeriodKey

    ,Sum(Consumo) as GranTotal

Resident Temp_valores

Where WildMatch(PeriodKey,'$(vMesWhereFilter)')

Group by PeriodKey;

Inner Join(ABC_Paso1)

LOAD PeriodKey

,GranTotal

Resident Temp_Total;

ABC_Paso2:

LOAD CodigoInsumo

,PeriodKey

,PromAcumulado

,ConsumoAcumulado

,GranTotal

    ,RangeSum(ConsumoAcumulado, Peek('Acumulado') * 1) AS Acumulado

Resident ABC_Paso1

Where WildMatch(PeriodKey,'$(vMesWhereFilter)')

Order by ConsumoAcumulado Desc;

ABC_Paso3:

LOAD *

,Acumulado / GranTotal as Inclusive

Resident ABC_Paso2;

ABC:

LOAD CodigoInsumo

,PeriodKey

,PromAcumulado

,ConsumoAcumulado

,If(Inclusive <= 0.85, 'A', If(Inclusive <= 0.95, 'B', 'C'))  AS ParetoClass

Resident ABC_Paso3;

</code>

Any suggestion will be well received. !

[ebrambilla]

Wonderful Juan Camilo, I will check your script! Thank you very much for sharing!

Ciao,

Emilio