Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ebrambilla
Contributor III
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
martynlloyd
Partner
Partner

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

Best regards,

M.

jcrincon
Contributor II
Contributor II

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.

Juan C. Rincon B, Demand Planner at Centro Medico Imbanaco de Cali
devarasu07
Master II
Master II

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

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

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

Juan C. Rincon B, Demand Planner at Centro Medico Imbanaco de Cali
ebrambilla
Contributor III
Contributor III
Author

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

Ciao,

Emilio