Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

selective display of tabs/dashboards

Hi, how can i create a button on a fresh tab such that when i click on it, only the dashboards for certain tabs will display and the rest will not show? Thanks.

12 Replies
Not applicable
Author

you can do this by using variables and a conditional show of sheets.

Create a variable say v1 and assign a value to it say 1

Create a button and assign an action to it. External -> Set Variable ->  let say 2

and in your sheets you can say $(v1) = 1

Not applicable
Author

where do i insert '$(v1)=1'?

Not applicable
Author

See the qvw.

Anonymous
Not applicable
Author

Hi,

You can handle this by using variable. Create variable, add action for that variable in button and use that variable on those tabs you don't want to show by using sheet conditional show option.

For example,

Create variable vEnable,

Create two button 1 for show and 2nd for hide,

Set vEnable=1 on 1st button and vEnable=0 on 2nd button,

Overlap both button on each other show that it will look only one button,

Now in sheet conditional show for those sheet use vEnable=0 condition.

Not applicable
Author

Hi, so sorry could you screenshot? I use personal edition so cant open

Siva_Sankar
Master II
Master II

Rachel,

Create a variable using  Settings Menu -> Variable Overview and create a variable

vShow =1

For sheet:

Sheet Properties -> Show Sheet -> Select Conditional and give =vShow

For Object:

Object Properties -> Layout -> Show -> Conditional -> and give =vShow

Now Create button and

Button Properties -> General -> Text -> Give If(vShow = 1, 'Hide', 'Show') ->

Actions -> Add-> External -> Set Variable -> Variable = vShow

Value = =If(vShow =1, 0, 1)

Not applicable
Author

Hi, thanks so much, but I followed your steps and created a button on a fresh tab. So now the new tab only has the button. How can I make it such that only when the button is clicked then the charts show? that means if the button is not clicked, the charts and data will not show. Thanks.

amit_saini
Master III
Master III

Hi Rachel,

Please see the attachment.

Thanks,
AS

Siva_Sankar
Master II
Master II

Rachel,

use the same variable which you used in button for chart also.

Example: if you have used the variable in button layout as vON=1, use the same variable in the chart, layout tab, select conditional and then use the variable.