Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This might be helpful -> Qlik Design Blog : Recipe for a Pareto Analysis | Qlik Community
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: