Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 sspawar88
		
			sspawar88
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		
Hi Community,
if i'm having one list box which are having seven department name.
i have created seven different table in which contain all related column of department separately.
how can i implement
--> When i click on one department name the related table should appear other should be hide.
what can i do for it in my qlikview application.?
 
					
				
		
 sspawar88
		
			sspawar88
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		yes.. thats my solution.
Thanks sunny.
 
					
				
		
 swuehl
		
			swuehl
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I am really, really glad we got this sorted out.
Regards,
Stefan
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I agree 
 
					
				
		
 sspawar88
		
			sspawar88
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
 
 parikshit88
		
			parikshit88
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi , The solutions is working for only one values.
In case in the same chart if I want to show data for multiple values then how to pass Dept1, Dept2 . . . values in the getfieldselections()?
please suggest.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be like this
=SubStringCount('|' & GetFieldSelections(Dept, '|') & '|', '|Dept1|') > 0
so, now if you select Dept1 and Dept2, Dept1 will still show up...
