topic Re: Yet on Pareto Analysis in QlikView

Yet on Pareto Analysis

ebrambilla — Thu, 24 Jul 2014 16:44:45 GMT

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!

Re: Yet on Pareto Analysis

martynlloyd — Wed, 10 Dec 2014 17:26:55 GMT

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

Best regards,

Re: Yet on Pareto Analysis

jcrincon — Wed, 20 Dec 2017 13:03:45 GMT

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.

Re: Yet on Pareto Analysis

devarasu07 — Wed, 20 Dec 2017 17:28:35 GMT

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

Re: Yet on Pareto Analysis

ebrambilla — Thu, 21 Dec 2017 08:26:08 GMT

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

Re: Yet on Pareto Analysis

jcrincon — Fri, 22 Dec 2017 12:17:12 GMT

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. !

Re: Yet on Pareto Analysis

ebrambilla — Fri, 22 Dec 2017 16:44:55 GMT

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

Ciao,

Emilio