Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
ebrambilla
New Contributor III

Yet on Pareto Analysis

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!

6 Replies
Partner
Partner

Re: Yet on Pareto Analysis

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

Best regards,

M.

jcrincon
New Contributor

Re: Yet on Pareto Analysis

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
Honored Contributor II

Re: Yet on Pareto Analysis

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

Highlighted
ebrambilla
New Contributor III

Re: Yet on Pareto Analysis

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
New Contributor

Re: Yet on Pareto Analysis

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
New Contributor III

Re: Yet on Pareto Analysis

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

Ciao,

Emilio