Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In my QV document I have two sheet objects Pivot Table and a bar chart. When I open the document both objects appear simultaneously in the screen . I want to show one object (pivot Table ) first and then after clicking a button bar char should appear next to Pivot Table when I click tiger some action while the pivot table should still be on display. Pls help to do this . My sample is attached herewith please
You can refer my application that single button is for hide and show at same .
You have to set action like this : =if(vHide=0,1,0), and set conditional for one chart vHide=1 and for other chart set it to vHide=0.
Check this , create a variable and set action set variable on the click of button. Check the attached file.
Dear Rai
Thanks. but I can not view your reply
You will a button that uses an Action to toggle a variable that controls whether the bar chart is shown.
The bar chart will use a conditional show that tests the variable. The attached sample demonstrates this. Let me know if you have an questions about the details.
-Rob
Dear Rob
Thanks
I have copied the button to document and created the vShowBarchart in variable overview. But it is not working. Can u pls advise what else I should do. Pls also elaborate me how an existing object can hide new object can display when trigging a button
Check the application attached in my previous reply.
Make sure you set the variable in the variable to an initial value of 0.
Can you upload a sample document that shows the trouble you are having?
-Rob
Now that problem I sorted out. My other issue is whether I can use action button to show one object hide other object in same action. pls help
You can refer my application that single button is for hide and show at same .
You have to set action like this : =if(vHide=0,1,0), and set conditional for one chart vHide=1 and for other chart set it to vHide=0.