topic Re: Hiding Tabs in QlikView

Hiding Tabs

Wed, 03 Feb 2016 12:52:57 GMT

Can anyone tell me how to hide a tab.

I know you can do this in document properties and it hides them for every sheet

but is there anyway you can do it PER sheet ?

Thanks

Re: Hiding Tabs

sunny_talwar — Wed, 03 Feb 2016 12:55:11 GMT

You can go into Sheet Properties and Conditional Hide it

Re: Hiding Tabs

Chanty4u — Wed, 03 Feb 2016 12:56:14 GMT

go to sheet properties--> general tab ---> conditional -----> make value as "0 "

Re: Hiding Tabs

Wed, 03 Feb 2016 12:56:30 GMT

I'm not sure how to do that ?

Re: Hiding Tabs

Anonymous — Wed, 03 Feb 2016 12:57:12 GMT

you can define it on every sheet under sheet properties

and define using Show sheet conditional to your requiremnets (e.g. vsheet1=1)

Re: Hiding Tabs

sunny_talwar — Wed, 03 Feb 2016 12:58:33 GMT

Go to Sheet Properties? Press Ctrl + Alt + S to go into Sheet Properties and then add a condition such as 1 = 0 to hide it

Re: Hiding Tabs

Wed, 03 Feb 2016 13:01:10 GMT

That makes it disappear but how do I reactivate it ?

What i am trying to do is click on a guage to activate a sheet (which it does)

but then for the tab brow to not be visible within that sheet.

Re: Hiding Tabs

sunny_talwar — Wed, 03 Feb 2016 13:03:51 GMT

Use variables in your case (in addition to activate sheet) to set its value to 1 or 0 (If(vVar =1, 0, 1)) and then use sheet condition as -> vVar = 1

Re: Hiding Tabs

Anonymous — Wed, 03 Feb 2016 13:04:49 GMT

define a button with Action external "set variable" (e.g. vsheet1 and Expression

"if (vsheet=1,0,1)

now define in sheet properties condittional (vsheet1=1= adn you can toggle with your button (donot plaqce the button on the sheet you want to hide!)

Re: Hiding Tabs

Wed, 03 Feb 2016 13:05:12 GMT

In Tab Settings (Right Botton over the Tab and then Sheet Properties) you can set a condition to show (or not) the Tab. Example 1=2 will be hide the tab.

You can do this with any qlikview object.

Hope it helps!

Regards,

Re: Hiding Tabs

stigchel — Wed, 03 Feb 2016 13:17:07 GMT

I think Harrisone would like to hide the complete tab row on this sheet instead of hiding particular sheets from the tab row. I'm I right?

It is not possible to hide the complete tab row for one particular sheet. A workaround could be to use document chaining, so instead of activating a sheet, opening another qvw file which has the tabrow hidden from the document properties setting.