Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Keeping a sum when a filter is selected

I have a sum of cost for states but when I select a filter, the sum of the state decreases. I was wondering how I can keep the cost for the state regardless of the filter. Below is a snapshot of it.

Before Filter:

Before Filter.PNG

After Filter:

After Filter.PNG

2 Replies
swuehl
MVP
MVP

You can disregard selections in specific fields using set analysis, like

=Sum({<Transfer= >} Cost)

to clear selections in field Transfer when summing Cost field.

Not applicable
Author

Awesome. It works. Thanks Swuehl!!!