topic How to activate hided sheet in QlikView

How to activate hided sheet

jagannalla — Thu, 26 May 2011 08:30:21 GMT

Hi,

- In mistake i've given a wrong condition in "Show Sheet" like this if( vGlobalId= 0 or 1,false(),true())

- Sheet is hided now, I'm not able see sheet now.

sheet id is "SH01"

Can anybody help me it is urgent for me.

How can i activate sheet now?

Thu, 26 May 2011 08:34:49 GMT

Hi,

Go to Settings menu --> Document Properties --> Sheets tab. There select the hidden sheet and click on Properties.

There you will be able to change the Show Sheet option.

magavi_framsteg — Thu, 26 May 2011 08:34:59 GMT

Hi jagannalla.

You can one of the following:

Press <ctrl+shift+s> (hold ctrl+shift and press s)
All objects throughout the document are shown.
Do not forget to roll back, because the document will be saved in the wrong state otherwise, and all objects will be shown regardless of condition
Fire up Settings > Document Properties and go to tab Sheets.
Select your sheet and press Properties...

Hope it works out for you.

prieper — Thu, 26 May 2011 08:36:38 GMT

You can always go to Settings -> Document Properties -> Sheets

There you will see all your sheets listed, along with the status (hidden or normal), mark it, go to Properties and change your layout-condition.

HTH

Peter

jagannalla — Thu, 26 May 2011 08:38:27 GMT

Thanks a lot.....it's working

jagannalla — Thu, 26 May 2011 08:42:41 GMT

Thanks a lot....It is a good idea with short cut key