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: 
ChrisCooil
Contributor II
Contributor II

Another Pareto Question!

So I've searched extensively on here to find an answer to my question but I'm coming up empty. I have a simple table of invoices tagged to suppliers. I want to count the number of suppliers that make up the top 80% of invoices.

SupplierIdValue
1100
2130
321
1344
256
212
1322

 

I've tried using Aggr and RangeSum but can't get it quite right. I don't think I can sort the Aggr by sum(value) to force the cumulative sum to not be based on load record number. I'm using QlikSense Cloud so no macro enabled solution is going to be right for me.

Labels (3)
5 Replies
Vegar
MVP
MVP

Maybe this discussion can be a interesting read for you? number of customer who makes 80% of turnover

 

Good luck!

ChrisCooil
Contributor II
Contributor II
Author

Thanks, I’d seen this one but I’m not sure how I’d translate this

1 - sum(aggr(sum(if(Week<=N,Amount))/sum(total Amount)<Limit,N))

into an expression that would work with my data. 

Vegar
MVP
MVP

Try something like this as suggested by @johnw  here

=-sum(aggr(rangesum(top(sum(Value),1,rowno()-1))/rangesum(top(sum(Value),1,noofrows())),SupplierId)<0.8)

 

 

ChrisCooil
Contributor II
Contributor II
Author

Thanks, so that is counting the number of suppliers as they are ordered in the load. I need it to order by sum(value) descending. So close!

sunny_talwar

Have you seen at this thread -> Recipe for a Pareto Analysis