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: 
Not applicable

Selectively filter graphs on a page

I'm new to Qlik and I've been tasked with something that is above my beginner status.  Below is a screen that has been filtered by "Owner" (Filter Box #1). What I need is to have Chart #2 NOT filter but display totals for all the Owners.  The intent is to create a "challenge" showing each Owner where they stand against the others.

Any help is appreciated.

Qlik Screenshot.png

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try expression like:

Sum({<OWNER>} Amount)

It could be any other aggregation function in place of sum(). This is called Set Analysis, learn about it from help.

View solution in original post

3 Replies
tresesco
MVP
MVP

Try expression like:

Sum({<OWNER>} Amount)

It could be any other aggregation function in place of sum(). This is called Set Analysis, learn about it from help.

Not applicable
Author

Thank you so much. That works perfectly.

Not applicable
Author

I've used Set Analysis in other instances but I had a mental block on this one.  Thanks again.