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: 
Not applicable

Identify count of vendors based on spend

I have vendor level information for different groups. I need to find out the number of vendors in each group based on the overall spend. For Ex: In Group A 100 Vendors contribute to 100% of the spend, i need to identify number of vendors contributing to 80% of the spend. Basically i need to put an input box, if a set it to 70% it shows me number of vendors contributing to 70% spend and so on. Would be helpful if somebody can help me in this.

Thanks,

Sumit

2 Replies
sunny_talwar

swuehl
MVP
MVP

You can use a pareto select action to select customers in an alternate state triggered by your variable change.

Something like attached, taken from an older post of me:

Background color depending of accumulated sum(sales)

There is also a more recent blog post by Oleg that describes something similar:

So How Many Customers Make Up Most of Your Sales?