topic Multiple Tabs in One Sheet in QlikView

Multiple Tabs in One Sheet

Fri, 21 Aug 2009 01:52:32 GMT

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.

Multiple Tabs in One Sheet

disqr_rm — Fri, 21 Aug 2009 09:40:50 GMT

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

Multiple Tabs in One Sheet

Fri, 21 Aug 2009 15:54:05 GMT

This shows buttons funtionalities

Multiple Tabs in One Sheet

Fri, 21 Aug 2009 20:30:00 GMT

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

Multiple Tabs in One Sheet

markmccoid — Mon, 24 Aug 2009 21:53:15 GMT

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

Multiple Tabs in One Sheet

Mon, 24 Aug 2009 21:59:06 GMT

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,

Multiple Tabs in One Sheet

markmccoid — Mon, 24 Aug 2009 22:25:50 GMT

Thank you Nigel.

Excellent solution!

Mark

Multiple Tabs in One Sheet

Thu, 27 Aug 2009 16:31:12 GMT

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.

Multiple Tabs in One Sheet

johnw — Sat, 29 Aug 2009 00:39:39 GMT

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.

Multiple Tabs in One Sheet

markmccoid — Mon, 31 Aug 2009 21:15:39 GMT

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

Multiple Tabs in One Sheet

Tue, 01 Sep 2009 00:05:38 GMT


John Witherspoon wrote:I've been reading this thread with academic interest, but also thinking, "Why wouldn't you just use the QlikView tabs?

Hi John,

Prior to this post I never really looked into this matter, but this posting made me realize that for some small and compact applications, especially for CEO/CFO's, this can be very convenient. It gives a nice, clean, and simple look which somehow seems to be favorable with these kinds of people (at least where I am working ).