Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide Object

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

2 Replies
Anonymous
Not applicable
Author

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.

Not applicable
Author

ok, works fine!

Thank you!

Mattex