Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Top x Percent

Hi guys having a bit of a strugle resolving a problem, lets say i have this table:

Company
Revenue
A200
B150
C130
D110
E90
F80
G60
H30
I20
J10

Now the total is 880 and im after a table that will show me Companies based on 80% of the top Revenues, 80% is 704, so basically my table would show me from company A to company F, that would make 760 thus showing me all the Companies that make at least 80% of the Revenue.

Many Thanks

1 Solution

Accepted Solutions
Not applicable

Re: Top x Percent

Hi

You can add a pareto selection button.

Look at the example.

If you clik on the button, it selects the company which achive 80% of the overall revenue !

JJ

2 Replies
Not applicable

Re: Top x Percent

Hi

You can add a pareto selection button.

Look at the example.

If you clik on the button, it selects the company which achive 80% of the overall revenue !

JJ

Not applicable

Re: Top x Percent

Many Thanks exactly what i was looking for.