topic Re: help in macro in QlikView

help in macro

ali_hijazi — Tue, 30 Oct 2012 11:59:05 GMT

Hello

I have a qvw document with one sheet this sheet contains several sheet charts

some of these charts are minimized by default

other are maximized

what I want is that when a user clicks a button all charts be minimized

but when the user clicks the button again the charts that were not minimized be resored

Please advise

Re: help in macro

jonathandienst — Tue, 30 Oct 2012 12:13:25 GMT

Add Layout | Minimize Object and Layout | Restore Object actions to your buttons. You can combine any number of actions for each button click.

On the buttons' Properties | Actions tab click Add and select the actions above. You can find the Object ID for each chart on the Properties | General tab for each object.

Hope that helps

Jonathan

Re: help in macro

Siva_Sankar — Tue, 30 Oct 2012 12:57:20 GMT

Hi, You can use the following macro code for minimizing... add macro sub Minimize ActiveDocument.GetSheetObject("CH03").Minimize ActiveDocument.GetSheetObject("CH08").Minimize ActiveDocument.GetSheetObject("CH09").Minimize ActiveDocument.GetSheetObject("CH11").Minimize . . . . . . ActiveDocument.GetSheetObject("CH20").Minimize end sub Similarly for maximize too... Hope it helps.. Regards. Siva