Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

s_santalucia
Contributor

Pareto Analysis for product

Hello,

is it possible to do Pareto Analysis for the products in stock?


ex.

Aggr(


    If(Rangesum(Above(count ({1} [%Art])/count ({1} total [%Art]),1,RowNo()))<0.8, 'A',


        If(Rangesum(Above(count ({1} [%Art])/count ({1} total [%Art]),1,RowNo()))>0.8 and

        Rangesum(Above(count ({1} [%Art])/count ({1} total [%Art])))<0.95, 'B',


            'C')),


    ([%Art],(=count({1} [%Art]),Desc))


    )


thanks!

4 Replies
ogautier62
Valued Contributor II

Re: Pareto Analysis for product

hi,

look at this :

Recipe for an ABC Analysis

and search in forum with pareto

regards

MVP
MVP

Re: Pareto Analysis for product

Would you be able to share more details as to what issues are you running into?

s_santalucia
Contributor

Re: Pareto Analysis for product

I have a problem with formula..

on the basis of the turnover, I have to divide the articles in stock. ie according to the ABC analysis, how many items of class A I have in stock?

MVP
MVP

Re: Pareto Analysis for product

Would you be able to share a sample where we can see the issue you are having?

Community Browser