Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
karin_nevo
Contributor III
Contributor III

Pareto calculation

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

3 Replies
sunny_talwar

karin_nevo
Contributor III
Contributor III
Author

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