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: 
rajany089
Contributor III
Contributor III

How to Ignore Specific Filters in a Bar Chart using Set Analysis in Qlik Sense

Hi Qlik Community,

I have a bar chart in my Qlik Sense app that I want to remain unaffected by specific filters. For example, I have a filter on the Region field, but I don't want this filter to impact the bar chart's measures. I understand that Set Analysis can help with this, but I'm not sure how to implement it correctly.

How can I modify the chart's measure to ignore filters on a particular field, such as Region? Additionally, how can I ignore all filters for that chart if needed?

Thanks in advance for your help!

Labels (1)
2 Replies
Qrishna
Master
Master

say your measure is Sum(Sales), you can ignore selections on Region by writing the expression as Sum({$<Region=>}Sales).

Sayed_Mannan
Creator II
Creator II

Hi,

To ignore specific filters in a bar chart using Set Analysis in Qlik Sense, you can modify the measure expression to exclude the filters on the desired field. Here's how you can do it:

// Ignoring a Specific Filter (e.g., Region)

Sum({<Region=>} Sales)

In this example, Sum(Sales) calculates the total sales, and {<Region=>} ensures that the Region filter is ignored.

// Ignoring All Filters

Sum({1} Sales)

Here, {1} indicates that all filters should be ignored, and Sum(Sales) calculates the total sales without any filtering.

I hope this helps!