topic Re: Pareto calculation in QlikView

Pareto calculation

karin_nevo — Thu, 24 May 2018 10:44:46 GMT

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 — Thu, 24 May 2018 10:57:17 GMT

Hi,

Try to use the Rank function

sunny_talwar — Thu, 24 May 2018 10:58:49 GMT

Check here

karin_nevo — Thu, 24 May 2018 11:26:28 GMT

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