topic Re: show all hidden sheets qlikview with macro? in QlikView

show all hidden sheets qlikview with macro?

Wed, 25 Nov 2020 16:16:04 GMT

can i show all hidden sheets qlikview with macro?

Re: show all hidden sheets qlikview with macro?

Frank_Hartmann — Fri, 25 Nov 2016 11:13:08 GMT

press

ctrl+shift+S

That will make hidden sheets visible.

hope this helps

Re: show all hidden sheets qlikview with macro?

Fri, 25 Nov 2016 11:26:53 GMT

I do this with a MACRO

Re: show all hidden sheets qlikview with macro?

Frank_Hartmann — Fri, 25 Nov 2016 11:41:35 GMT

then you will have to setup a QV Variable e.g vshow.

then just add this variable with condition vshow=1 only to your hidden sheets.

then you are able to set the value vshow by macro:

Function setVariable

set v=ActiveDocument.Variables("vshow")

v.Forcecontent "1",1

END function

hope this helps!

Re: show all hidden sheets qlikview with macro?

rubenmarin — Fri, 25 Nov 2016 11:43:34 GMT

Hi Maurizio, you can add a variable value to the show condition of the sheets, with a macro changing the variable value the sheets will be shown/hidden.

But in this case I think it will be better changing the variable value with actions instead of doing it with a macro:

1. Create variable vShowSheets (or the name you want, with default value 1 or 0)

2. Add action 'External'->Set variable

3. Variable: vShowSheets

4. Value: If(vShowSheets=1, 0, 1)

5. Add this variable to Sheet conditional show

Re: show all hidden sheets qlikview with macro?

el_aprendiz111 — Fri, 25 Nov 2016 12:31:10 GMT

Hi,

MACRO:

Re: show all hidden sheets qlikview with macro?

tamilarasu — Fri, 25 Nov 2016 17:28:13 GMT

Hi Maurizio,

After some research I think it's not possible to show all the sheets through macro. You can use either Ctrl + Shift + S key combination manually or some work around like mentioned above. I tried various various methods but no luck so far. I even tried sendkeys in macro but unfortunately the key specific key combination seems not working. someone has explained the reason in below link.

SendKeys does not work for a particular key combination in QlikView 11 - Stack Overflow

As mentioned by others you can assign variables in each sheet (including hidden) and show / hide them by using macro.

Re: show all hidden sheets qlikview with macro?

Thu, 01 Dec 2016 10:23:08 GMT

thank you!!