Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
see tis,
Got it, thank you for prompt response.
cheers
if ur happy with tht sol,please mark as correct