Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

New Contributor

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
Valued Contributor II

Re: Block Filter From Chart

the equivalent set analysis  of you sum() could be


New Contributor

Re: Block Filter From Chart

It worked.

Thank you.