This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I got a qvw document in which I need to create a menu that can be hidden
I'm trying to add a container with grid style and add to it sheet objects representing menu items
I added a button so as to hide this container menu using the following macro:
set sh = ActiveDocument.ActiveSheet
dim dummy(0) 'dummy array indicates all parts of frame to be set
set fr = obj.GetFrameDef
set pos = fr.Rect
pos.Width = 0
pos.Height = pos.Height
however when I click the button I get an error on the red line above
The easiest thing would be to use a variable for the object/sheet you want hidden combined with a show condition.
vHidden = '1'; //Hidden
Then set the show condition for the container in your case to be if(vHidden='0')
And finally have the button toggle the value between 1 and 0
i think that i will be easyer to not use macro here...
i usually use simple click action:
the click action activates a variable that get '1' or '0' - somthing like " if (<variable name> = 1 ,0,1)
than for your container that holds the menu, in properties - layout, switch the show to conditional and set it to <variable name>=1
the result will be that with a simple click you can make the menu to apear or disapear.