Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can i show all hidden sheets qlikview with macro?
press
ctrl+shift+S
That will make hidden sheets visible.
hope this helps
I do this with a 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.
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!
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
Hi,
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.
thank you!!