Show/Hide objects using buttons in the Qlik sense

[Rsaiq]

I have a sheet in a Qlik Sense app that contains KPIs, text objects, tables, and a button labeled "New Data."

I have added navigation to the button so that when a user clicks "New Data," it navigates to new sheet that contains a straight table. (This is working fine.)

Now, my requirement is: instead of navigating to a new sheet, can we hide all the objects on the first sheet (such as KPIs, text objects, tables, etc.) and display the straight table that is currently on the new sheet?

[Daniel_Castella · Accepted solution]

Hi @Rsaiq 

I think the only way to do this is with the Layout Container. You can find this object in Custom Objects -> Qlik Dashboard bundle.

There, you can put different charts and master items ones over the others and show or hide them through the Show Condition. And obviously, the Show Condition can be managed with a button using variables.

Let me know if you have any doubt but I think that, if you can find this object, it is easy to understand how it works.

Kind Regards

Daniel

[N30fyte]

First create a variable to toggle display/hide. I called mine vShowStraightTable. Set its initial value to 1.

Create a button that toggles the value of this variable between 1 and 0: the button action is Set variable value, the Variable is vShowStraightTable, the Value is if(vShowStraightTable=1,0,1).

Create a layout container and drag all your design elements including the straight table into it. For the text/KPIs/tables etc, set the Show condition to vShowStraightTable = 0. For the straight table, set the Show condition to vShowStraightTable = 1. 

Adjust the area of the layout container to fit your sheet, and lay out the various elements as desired.

Click the button to switch the display.

[Amit_Prajapati]

Hi @Rsaiq  , You can do it with the help of steps shared by @N30fyte .

With the help of Layout container.

[Rsaiq]

Hi @N30fyte ,

Thanks for you response.

I created a custom design for the first sheet, similar to the attached sample.If I add all the objects into a container, they will not appear as I designed; instead, they will appear in a tabbed format. That is my concern.

For example, in Sheet 1 (as shown in the attached sample), I have 7 text and image objects, 7 KPIs at the top, followed by 2 more text and image objects, 7 buttons and then 4 straight tables.
In Sheet 2, I have only a straight table.

My requirement is that when the user clicks on the Sales button, all the objects in Sheet 1 (as shown in the attached sample) should disappear, and the straight table from Sheet 2 should appear—so that I can have only one sheet.

Thanks in advance

[Rsaiq]

Hi @Daniel_Castella ,

Thank you for your response.

I found Layout Container, am working on it.

I will post queries and if i have any issues, it will be very helpful for your help.

Thanks in advance

[N30fyte]

Hi @Rsaiq 

Try it with a Layout Container (from Custom Objects - Qlik Dashboard Bundle). This gives you the freedom to adjust the size and alignment of the individual charts and tables within it. A Tabbed Container won't do the job.

Cheers,

N