Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 chriscools
		
			chriscools
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello,
how can i make an object dissapear if there is no month selected?
i want the object only to appear if there is no selection in the field "Month".
thanx!
chris
 
					
				
		
Hello Chris,
you can create Calculated dimension some thing like if(isnull(getfiledselections(Filed)),Object)
this may not hide the object but it might help you.
Thanks & Regards,
Venkat T
 
					
				
		
 sivarajs
		
			sivarajs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Chart Properties--> Layout -->Show--> Conditional--> if(getselectedcount(field)=1,1,0)
1-show 0-Hide
 
					
				
		
yup...i thought the requirement is to hide the particular dimenison not the entire Object like chart or table...
but thanks for Sivaraj...
Thanks & Regards,
Venkat T
 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
In Chart Properties -> Layout -> Show -> Select Conditional
then give the following expression
=If(GetSelectedCount(DimensionName) > 0,1,0)
Hope this helps you.
Regards,
Jagan.
 
					
				
		
See this: http://community.qlik.com/thread/65307
 
					
				
		
Looked like magic.  
But i need to display a message if a month was not selected instead of entire chart to disappear. How do i do that?
Thank you.
 buzzy996
		
			buzzy996
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		see tis,
 
					
				
		
Got it, thank you for prompt response.
cheers
 buzzy996
		
			buzzy996
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		if ur happy with tht sol,please mark as correct 
