topic Showing / hiding sheets in QlikView

Showing / hiding sheets

oxiofrt — Fri, 03 Jul 2009 21:40:16 GMT

Hi,

I would like to be able to use buttons to show / hide sheets.
Is it possible ? I have only found : ActiveDocument.Sheets("Feuille 2").activate

Thanks a lot for your help.

Showing / hiding sheets

Anonymous — Fri, 03 Jul 2009 22:05:38 GMT

Same as showing/hiding objects - use a variable as a condition to hide/show, and toggle the value of the variable with a button.

Showing / hiding sheets

Fri, 03 Jul 2009 22:06:02 GMT

Have the macro attached to the button toggle the value of a variable (if 0 set to 1 else set to 0) and then condition the 'show' of the sheet depending on the value of the variable.

Hope this helps.

Gordon

Showing / hiding sheets

oxiofrt — Fri, 03 Jul 2009 22:29:02 GMT

ok for the macro but how to "condition the 'show' of the sheet" ?

Showing / hiding sheets

Fri, 03 Jul 2009 22:35:30 GMT

Sheet Properties>Show sheet