Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

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.

0 Replies