Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mmainiero
Contributor II
Contributor II

How to calc Border

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.

How to calc Border.jpg

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.