Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.