Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Block Filter From Chart


I just read many discussion on this subject and to no avail.

As the landing page in Qlik Sense I would like to display our businesses share by Province. I have 4 common filters:

1. Business Type

2. Year

3. Month

4. Province

My chart for each province is correct until a province is selected. When one province is selected all other charts go blank. As a landing page, I would like to restrict the charts on this page to not be filtered be province, but allow the other 3.

I will not list all that I have tried, but here is what I currently have in one of the charts for Ontario which is correct till an individual province is selected.

=sum(if([HHG_OrigProv] = 'ON' , HHG_Weight))

"HHG_OrigProv" is also the filter I am try to block for the charts on this page.

I believe I can you set analysis, but cannot seem to get it correct.

Thanks for any help you can provide.

2 Replies
Specialist III
Specialist III

the equivalent set analysis  of you sum() could be



It worked.

Thank you.