topic Re: Hide a Tab in QlikView

Hide a Tab

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

I want to hide tab always and show it when i want.

Thanks

Re: Hide a Tab

Wed, 01 Jun 2016 06:11:12 GMT

u can use hide Tabrow property in Document properties..

Re: Hide a Tab

vikasmahajan — Wed, 01 Jun 2016 06:15:50 GMT

Document Settiong -> Hide Tabrow

Re: Hide a Tab

anuradhaa — Wed, 01 Jun 2016 06:29:49 GMT

I want to hide only one tab and not the tabrow

Re: Hide a Tab

Anil_Babu_Samineni — Wed, 01 Jun 2016 06:33:45 GMT

Can you please confirm me which tab you want hide. I mean from Scripting / Sheet Tab...!

Re: Hide a Tab

vikasmahajan — Wed, 01 Jun 2016 06:35:07 GMT

This way you can give condition and hide one tab formula 2 < 1 ( False) so tab will be hidden

Re: Hide a Tab

Anonymous — Wed, 01 Jun 2016 06:35:09 GMT

Right click on the tab you want to hide and select properties.

Then on the general tab of the sheet properties box go to the show sheet section in the top left of the box and select the radio button for conditional. Finally enter the condition you want to use to show or hide your sheet and that will do it.

Kindest Regards

Brian

Re: Hide a Tab

PrashantSangle — Wed, 01 Jun 2016 06:40:32 GMT

Hi,

go to sheet property > General > Conditional> write any condition which is never true like 1=2

Regards

Re: Hide a Tab

kristof_j — Wed, 01 Jun 2016 06:43:28 GMT

Create a variable vShow with value 1

Then right click on a sheet background, go to 'Gerenal' and fill 'vShow' next to 'Conditional'

The sheet will hide the moment you change vShow to value 0

You can also create a button or a text object. Go to Actions, choose 'set variable' under 'External'

And then fill in the following expression

Re: Hide a Tab

susovan — Wed, 01 Jun 2016 06:50:52 GMT

Hi Anuradha,

First of all go to the Sheet properties in which sheet you want to hide and than give the calculation condition.

Re: Hide a Tab

Anil_Babu_Samineni — Wed, 01 Jun 2016 06:54:23 GMT

If i want to get again so how ?

Re: Hide a Tab

Anonymous — Wed, 01 Jun 2016 06:57:10 GMT

What is your scenario for showing or hiding the tab? Could it be based on a selection or would using a button to toggle a variables value be better?

Re: Hide a Tab

susovan — Wed, 01 Jun 2016 07:05:58 GMT

Suppose you give this Condition in Sheet properties 'vShowTab=1',

If you change this variable definition from settings->variable overview then show this tab again.

Variable defination :

'vShowTab=1' for Show

'vShowTab'=0 for Hide