Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to determine the number of "Customers" for each "Location" which generate 10% or 35% of the total "Location" value?
It should be the "Customers" with the highest single "Values".
I also want to list these "Customers".
Here in Excel: 10% are in Green. I want the number of Customers an which they are in Qlik.
Have a look at the following Design Blog posts, believe they may be helpful:
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684
If you wish to search further on your own, here is the base URL for the area:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett