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

[rajany089]

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!

[Qrishna]

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

[Sayed_Mannan]

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!