Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 mario-sarkis
		
			mario-sarkis
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		
Dear All,
well i am working on a dashboard i have in several sheets Ex:
Sheet 1 , Sheet2 , Sheet3
when i select on ID in sheet1 this will filter also sheet 2 and sheet3 by this ID (this is not a problem to me )
my problem is when i select an ID in the sheet 1 i want to clear this selection when moving to sheet 2 or 3.
Help.
Thank you,
 
					
				
		
 jsanchezh
		
			jsanchezh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
You can try this:
>> Right click with your mouse on "Sheet1"
>> Sheet Properties
>> The last tab after security (which should be something like trigger or shooter, i have Qlikview on my language)
>> Then "add actions" when leaving the sheet
>> Add >> Selection >> Delete Field and then you can select your field (ID)
I hope it helps you
Greetings!
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Settings
Sheet Properties
Triggers
OnLeaveSheet >> Add Action
Add
Selection
Clear All
 
					
				
		
 jsanchezh
		
			jsanchezh
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
You can try this:
>> Right click with your mouse on "Sheet1"
>> Sheet Properties
>> The last tab after security (which should be something like trigger or shooter, i have Qlikview on my language)
>> Then "add actions" when leaving the sheet
>> Add >> Selection >> Delete Field and then you can select your field (ID)
I hope it helps you
Greetings!
