Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s_santalucia
Partner - Creator
Partner - Creator

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

hi,

look at this :

Recipe for an ABC Analysis

and search in forum with pareto

regards

sunny_talwar

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

s_santalucia
Partner - Creator
Partner - Creator
Author

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?

sunny_talwar

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