topic Re: Sub tabs in main sheet in QlikView

Sub tabs in main sheet

Sun, 22 Mar 2015 07:31:35 GMT

Hi,

I'm new to qlikview...How to create the sub tabs in main tab itself...

Headcount is my main sheet name under this sheet, Region and Organization units are sub tabs.

Please help me.

Re: Sub tabs in main sheet

Agis-Kalogiannis — Sun, 22 Mar 2015 18:45:07 GMT

Hi Usha

You can work in two different ways:

1. Create a container object on the sheet, and this will give you the option of having 'secondary' tabs, each one representing an object.

2. Add text objects, with actions, that can be used as buttons, but will look like a tabrow. These text objects (or buttons) will have an action that will change the value of a variable and the objects will hide or show depending on the variable value.

For more information chech the following:

http://community.qlik.com/message/629742#629742

I hope this helps

Regards

Agis

Re: Sub tabs in main sheet

Sun, 22 Mar 2015 20:25:07 GMT

Hi,

Please find this link..

Welcome to Saki Soft

might be useful

Re: Sub tabs in main sheet

Wed, 10 Jun 2015 14:53:11 GMT

Helpful

Re: Sub tabs in main sheet

punitpopli — Fri, 26 Jun 2015 19:17:46 GMT

Hi usha1234‌

Please find the attached application, I think this is what you are expecting

Steps to achieve this :

Create a variable , currently vActivateSheet

Create two text boxes, add action set variable (vActivateSheet) as Reg and Org based on two sheets

Name both the sheets as HaedCount and link both the buttons

Now add conditional enable condition on sheet Reg as : vActivateSheet='Reg' as on Sheet with Organisational data as vActivateSheet = 'Org'

Based on the button click each sheet will get enable and it will look as we have subtabs within main heading

Hope this will help

Thanks,

Punit

Re: Sub tabs in main sheet

Anonymous — Fri, 29 Apr 2016 15:26:05 GMT

You are switching between Text boxes in this example. What if I want to use this functionality on other objects such as Charts, MultiBox or List boxes?

Re: Sub tabs in main sheet

punitpopli — Wed, 04 May 2016 12:52:14 GMT

You can use conditional "Conditional" property under Layout >Show based on the requirement the respective chart/Multibox/Listbox can be shown or hidden.

The objects can be shown/hidden based on some action or selection.

Let me know if any if this helps you!

Regards,

Punit

Re: Sub tabs in main sheet

engishfaque — Wed, 04 May 2016 16:00:48 GMT

Dear Usha,

This is best suggestion from my side, move your tab names into separate excel sheet and load that sheet in QlikView after that use these names into your QlikView App. This will help you a lot in future.

Kind regards,

Ishfaque Ahmed