Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
where do i insert '$(v1)=1'?
See the qvw.
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.
Hi, so sorry could you screenshot? I use personal edition so cant open
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)
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.
Hi Rachel,
Please see the attachment.
Thanks,
AS
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.