Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 rajany089
		
			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
		
			Qrishna
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		say your measure is Sum(Sales), you can ignore selections on Region by writing the expression as Sum({$<Region=>}Sales).
 Sayed_Mannan
		
			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!
