Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
My requirement will 3 sheets, Those 3 sheets need to include into single sheet in Qlik sense.
When I clicked Sheet1 it need to show as mentioned below.
When I clicked Sheet2 It need to show as mentioned below.
when I clicked Sheet3 it need to show as mentioned below.
sheet 1:
Filter1, Filter2, Filter3, Filter4 and respective grid of sheet1
Sheet 2:
Filter1,Filter2,Filter3 and respective grid of sheet2
Sheet3:
Filter1,Filter2 and respective grid of sheet1
Please provide step by step process if anyone know how to achieve the above requirment.
Hi,
Create a variable, for example, `vSheet = 1`.
Create 3 buttons that reference this variable:
Sheet 1, Sheet 2, Sheet 3.
For each button, define the actions:
Sheet 1 – Add an action to set the variable to the value 1, clear selections
and insert a Navigation action pointing to your sheet (e.g., "My Sheet 1").
Sheet 2 – Add an action to set the variable to the value 2, clear selections
and insert a Navigation action pointing to your sheet (e.g., "My Sheet 2").
Sheet 3 – Add an action to set the variable to the value 3, clear selections
and insert a Navigation action pointing to your sheet (e.g., "My Sheet 3").
In the "Show Condition" for the sheets, enter the value corresponding to each sheet's action.
______________________________________________________________________
If you still need it to be on a single sheet, you will have to use a Container object. Note that, depending on your scenario, you might encounter performance issues—which is why I mentioned the first option. You can follow the same process, but instead of setting the show condition on the sheet itself, you would apply the show condition within the container object's layout settings.
Regards, Matheus
Hi, if you need your sheets in one sheet you can use the "designer layout" object.
There you can set the different objects in any position you want and use the variable proposed by @MatheusC to hide/show the different objects