Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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