Show/Hide Container

[MeeraAgrawal]

Hi Guys

I am using Qlik sense and not able to see show/hide container visual can you please tell me why it's happening and please guide me how to insert it.

[ArnadoSandoval]

Hi @MeeraAgrawal 

I could misunderstood you question, anyhow the screenshot below show a Container with two tabs (Sales Representatives and Customers), a Variable Input with two options Representatives and Customers; on the right panel the Customer KPIs properties is visible, in the "Show Condition" property the condition become 1 when the Customers button is selected (the variable vTargetView is updated by the Variable Input. If this is not what you are asking, would you elaborate on what you want to do?

Hope this helps,

[MeeraAgrawal]

Hi @ArnadoSandoval 

Thanks for your response

I have 3 different sheet 

Sheet1-World Information

Sheet2-State Information

Sheet3- Table Information

Now Sheet3 contain container with 2 table for world and state information and sheet 1, sheet 2 having button to go sheet 3.

Now I want when I click from sheet1 to sheet3 then world information get visible and state are hide when I will click from sheet2 to sheet3 then world information get hide only state wise table get show.

Note* I have attached screenshot of three sheets. and I m working on Qlik cloud

[ArnadoSandoval]

@MeeraAgrawal 

Follow these steps:

1. Create a variable: vSheetNo, with a default value of 1; e.g. Sheet number 1
2. With Sheet1-World Information, edit mode -> Actions -> Set Variable Value -> select vSheetNo with a value of 1
3. With Sheet2-State Information, edit mode -> Actions -> Set Variable Value -> select vSheetNo with a value of 2
4. With Sheet3- Table Information, edit mode -> Click on the Container -> Expand its first tab (World) -> edit the Show Condition with the expression: If(vSheetNo = 1, 1)
5. With Sheet3 Table information, edit mode -> Click on the Container -> Expand its second tab (Countries) -> edit Show Condition with the expression: If(vSheetNo = 2, 1)

These are the screenshot for each step:

Step 2: Create variable vSheetNo

Step 3: Add action to set vSheetNo to 1 on your first sheet.

Steps 3 and 4: Add the Show Expression for each tab of the container:

Hope this helps,

[MeeraAgrawal]

Hi @ArnadoSandoval 

I am able to hide tab by applying these tabs but how to connect this with 2 buttons in Sheet1 and Sheet2 both are having option to navigate sheet 3 . When I am navigating from sheet1 and sheet2  i am able to visible same table. In short table not playing hide and show while navigating through buttons.

[ArnadoSandoval]

@MeeraAgrawal 

Sorry mate, your sheets are very crowded, you should be more specific when talking about a button on them, I did not see them on the previous screenshot you posted.

Regards,  

[ArnadoSandoval]

@MeeraAgrawal 

I saw the Buttons, could you apply the same logic of assigning a value to the vSheetNo accordingly when clicking those buttons.

Regards,

[MeeraAgrawal]

Hi @ArnadoSandoval 

I tried to apply variable to Button as well, as container but now both table not visible please find screen shot.and please elaborate this expression also =if(vSheetNo=1,1) and =if(vSheetNo=2,1) here last common 1 what representing.

[ArnadoSandoval]

Hi @MeeraAgrawal 

It should work, I added two bottoms to force the container to show a tab and it worked for me, the vSheetNo only accept two values: 1 or 2; the only way I found for the container to show none of its tabs was by deleting the variable vSheetNo.

Can you share your project? or trace the values of your vSheetNo variable, somehow it is getting a value other than 1 or 2; if its value become 0 or >=3 the container will show no tabs.

HTH

[MeeraAgrawal]

Hi @ArnadoSandoval 

I am using Qlik cloud and not able to find share option.