topic Identify count of vendors based on spend in QlikView

Identify count of vendors based on spend

Sun, 07 Feb 2016 19:05:15 GMT

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

Re: Identify count of vendors based on spend

sunny_talwar — Sun, 07 Feb 2016 23:51:59 GMT

This might be helpful -> Qlik Design Blog : Recipe for a Pareto Analysis | Qlik Community

Re: Identify count of vendors based on spend

swuehl — Mon, 08 Feb 2016 00:31:17 GMT

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?