Hide Object

Sun, 19 Jul 2009 16:45:13 GMT

Hi,

i want hide the list box of months by use "show contional", when the chart of sell is minimized.

help pls. i use qlikview enterprise 6.

thanks,

Mattex

ps:sorry for my english

Hide Object

Anonymous — Sun, 19 Jul 2009 21:17:08 GMT

Mattex,
You certainly can do it by using a macro. But first you need a variable that you'll be using in "show condition". So,
1. Create a variable, let call it vShow.
2. In your list box, use show condition =vShow.
3. Macro:


sub Show
 set v=ActiveDocument.Variables("vShow")
 set ch=ActiveDocument.GetSheetObject("CH01")
 if ch.IsMinimized then
 v.SetContent 0, true
 else
 SetContent 1, true
 end if
end sub

4. Now, you have to decide what event is good to trigger the macro. It may be assigned, for example, to "Activate chart CH01". But it is just my assumption, it can be right or wrong in your specific situation. Besides, keep in mind that the macro should be triggered also by the events that you want to show the list box again.

Hide Object

Sun, 19 Jul 2009 23:59:37 GMT

ok, works fine!

Thank you!

Mattex

topic Hide Object in QlikView

Hide Object

Hide Object

Hide Object