Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

show all hidden sheets qlikview with macro?

can i show all hidden sheets qlikview with macro?

7 Replies
Highlighted
Master II
Master II

Re: show all hidden sheets qlikview with macro?

press

ctrl+shift+S

That will make hidden sheets visible.

hope this helps

Highlighted
Not applicable

Re: show all hidden sheets qlikview with macro?

I do this with a MACRO

Highlighted
Master II
Master II

Re: show all hidden sheets qlikview with macro?

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.

Unbenannt.png

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!

Highlighted

Re: show all hidden sheets qlikview with macro?

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

Highlighted
Specialist
Specialist

Re: show all hidden sheets qlikview with macro?

Hi,

MACRO:HideSheet.gif

Highlighted

Re: show all hidden sheets qlikview with macro?

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.

Not applicable

Re: show all hidden sheets qlikview with macro?

thank you!!