Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
mmainiero
New 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
Highlighted
Digital Support
Digital Support

Re: How to calc Border

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.