topic Re: Urgent - Hiding and Unhiding Tabs in QlikView

Urgent - Hiding and Unhiding Tabs

Mon, 23 Jan 2012 15:21:47 GMT

Hi All,

I need help.

I have two tabs ("Tab1" and "Tab2"). I am trying to add a button as an object in "Tab1" which shall have a trigger which would hide
"Tab1" and display "Tab2" and i would like to have a similar button in "Tab2" which would hide "Tab2" and display "Tab1"

The eventual idea is to have the same name for both the tabs (Ex. "Tab") so that it would look like a single tab to users.

Not sure as to how this can be achieved. It would be great if anyone could share an example how to accomplish this.

Thank you!

Regards,
Harsha

Re: Urgent - Hiding and Unhiding Tabs

Miguel_Angel_Baeyens — Mon, 23 Jan 2012 15:36:10 GMT

Hi Harsha,

This can be easily achieved using variables, buttons with actions and conditionals in the visibility of the sheet. First you need to create as many variables as tabs (2 in this case). Then set each tab visibility to conditional (Sheet properties, General, Show Sheet, Conditional) when the variable has 1 as value

vTab1Visible = 1

The button has both the text and the action dynamic, so when the tab is visible, the text shows "Show Tab2" and the variable is set to the opposite value (1 visible, 0 hidden) and viceversa.

Hope that helps.

Miguel

Re: Urgent - Hiding and Unhiding Tabs

dwh1104 — Mon, 23 Jan 2012 15:37:46 GMT

Create a variable where you could set it to 1 or 2. For this case, let's call it vTabShow.

For your button on tab1, under Actions, you will Set Variable. (Variable: vTabShow Value: 2) Then do an Activate Sheet and call Tab2.

Under the Sheet Properties, you will do a conditional show. For tab1, it will be vTabShow=1 and for tab2 it will be vTabShow=2.

Do the same on the button that is placed on tab2. (Variable: vTabShow Value: 1) Then do an Activate Sheet and call Tab1.

Urgent - Hiding and Unhiding Tabs

Wed, 25 Jan 2012 12:08:12 GMT

Worked Perfectly!

Thank you Dan Heller and Miguel 🙂