Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Make selections based on % of total

I would like to be able to be able to make a selection based on choosing a 80% (as an aexample) of the total.

For example

If I have 50 clients - I want to be able to choose which of these clients make up the top 80% of all sales. I don't just want an object that would show the top 80% (using dimension limits) but actually want the top 80% selected so the other objects in the file respect this selection.

Example

Client  Revenue

A          10

B          20

C          30

D          50

In the above example clients C and D would be selected because they are the top clients = 80% and all other objects would respect this selection.

Community Browser