Multiple Tabs in One Sheet

[#1]

Is there anyway to create multiple tabs in one sheet?

I have around 15 Tabs and would like to group them down to about 6.

[disqr_rm · Accepted solution]

See enclosed. Good example of how you can use buttons to simulate "sub tabs". Hope it helps.

[#3]

This shows buttons funtionalities

[#4]

This is exactly what I was looking for!!! Thank you so much!!!

[markmccoid]

Hi,

How are you accomplishing the switching out of list boxes when a button is pushed. It doesn't look like there is any macro code for it?

Looks good, just not seeing how it is done.

Thanks,

Mark

[#6]

Hi

The button is linked to a macro and the mcro will simply change the value of a variable, for example, I am including up to 6 "tab" buttons at the top of my screen and each of those are linked to a different macro, but the macro changes the same variable (For eg: vTabSelected) so button one will change the variable to be "Performance Data" and button two will change the same variable to be "Summary".

On each of my list boxes, charts, tables I use a conditional show command where, for example, my conditional show will be vTabSelected='Performance Data'

This means that my objects only show when the appropriate button at the top is selected.

Note: The buttons themselves also have conditional background colour formatting so that they turn grey when selected, and are transparent when not selected, this means that the user always knows which tab is active.

Any other questions, let me know.

Regards,

[markmccoid]

Thank you Nigel.

Excellent solution!

Mark

[#8]

Guys, I'll throw my tuppence worth into the ring...

Another way of achieving this is without the use of Macros... provided you aren't wanting vertical labels.

In your script, load an INLINE table similar to this:-

LOAD * INLINE [
TabName, ShowFlag
TabA, 1
TabB, 2
TabC, 3
];

Now create a list box off the TabName field, remove its caption bar etc, and set it so it isn't a single column - position it across the top. Set the sort to Load Order and not state, and finally set it so there is always 1 item selected.

On each object on your sheet, use the conditional show property eg

ShowFlag=1 to show when TabA is selected.

Attached is a simple example.

[johnw]

Heh. I've been reading this thread with academic interest, but also thinking, "Why wouldn't you just use the QlikView tabs? Why reinvent the wheel?" Then mdk's post made me realize that I've already done this myself in two or three applications. I have a horizontal list box at the top with several options, and each option shows a different set of objects on the screen. However, all of the sets of objects are related to each other, so I felt they were best grouped on a single tab. I suppose there's really not much conceptual difference between that and simply making your own "tabs" for the entire application. It's just a matter of how far you want to take it.

[markmccoid]

Hi,

I used this to create a "Quick Criteria" button. A button that when pushed shows a group of list boxes with fields a user can use to narrow down their search. They click the button again and the list boxes disappear.

This worked great in the fat client, but when I tried it using the IE plugin I got some strange results. Things like even though my "show/hide" variable was set to hide all the fields, a ghosted outline remained.

The thing that I am doing differently than the examples given here is that I am using the QlikView tabs and have my "Quick Criteria" buttons on multiple tabs.

An example, would be on QV Tab1 I have a "Quick Search" button and click it to show my extra criteria fields. I then click the button to hide these fields. I then go to Tab2 and do the same thing I did on Tab1, lastly I go back to tab one and I see my extra criteria list boxes flash on then off, but the background text boxes are leaving a "ghosted" border behind.

Just curious if anyone else is seeing anything like this.

Thanks,

Mark