Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
hi,
I just started to learn Qlik Sense,I'm sorry about the problem that I was sending out.
What I want is that when I select a filter , I can't select another filter。
For example,
if I select "1年" in the "time" filter,I can't select any option in the "product" and "Infor" filter,Of course, I can continue to select “2年” or “3年” in the "time" filter.
if I select same options in the "product" or "Infor"filter,I can't select any option in the "time" filter.
And all the data comes from a table.
Can you solve this problem with an expression?
Thank you in advance。

消息编辑者为:lisa lu
 
					
				
		
 vinieme12
		
			vinieme12
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		is this what you are after?
Comparative Analysis - Alternate States with Qlik Sense
 MK9885
		
			MK9885
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Using your Inline code I can see and select the City values. Not sure what problem you facing?
Check your Data model and it's association with other tables.

 
					
				
		
I've tried it, but it's still wrong.
Expression for Country:
=if(getfieldselections(City)>0 ,null(),Country)
Expression for City:
=if(getfieldselections(Country)>0 ,null(),City)
I select the "A" in "Country", and then "a1", "a2", "a3" in "City" will be automatically selected, and the two filters will be automatically hidden.

