Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: selective display of tabs/dashboards

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

Re: selective display of tabs/dashboards

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

Not applicable

Re: Re: selective display of tabs/dashboards

See the qvw.

satyadev_j
Valued Contributor

Re: selective display of tabs/dashboards

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

Re: selective display of tabs/dashboards

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

Siva_Sankar
Honored Contributor

Re: selective display of tabs/dashboards

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

Re: selective display of tabs/dashboards

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
Honored Contributor III

Re: selective display of tabs/dashboards

Hi Rachel,

Please see the attachment.

Thanks,
AS

Siva_Sankar
Honored Contributor

Re: Re: selective display of tabs/dashboards

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.

Community Browser