Re: Pareto calculation - Qlik Community

karin_nevo · ‎2018-05-24

HI,

I am trying to get the total suppliers with 80% of the purchase orders amount.

I was able to do it in a straight table, by using the following expression:

= sum ( aggr ( If ( Rangesum ( Above ( sum ( Amount) ,0 , Rowno() )) / sum ( Total Amount ) <= 0.8, 1 , 0) , BP ))

This expression works if the table is sorted by purcahse order amount in a desc order.

But, I want to use this in a text object to display only the count of suppliers with 80% of the purchases.

If I use the same expression in text object it doesn't display the correct result becasue there is no sort.

I know in QV 12 there is a solution for it in AGGR fucntion, but I am using QV11.

Thanks,

Karin

jmvilaplanap · ‎2018-05-24

Hi,

Try to use the Rank function

sunny_talwar · ‎2018-05-24

Check here

karin_nevo · ‎2018-05-24

Thanks, but as I see they it refers to the same AGGR function with QV 12 or use a button to calculate the pareto (which is not what I need).