How can you show the chart with the button click?

[#1]

I have 2 buttons and 2 charts.I want to  show the fisrt chart when I click first button and when I click the 2nd  button the first chart will dissappear and the second chart will display.How can I do this?

Thanks in advance for your help.Thank you.

[yduval75]

Hello,

You have to create a variable vDisplay

The triggers of each button will give values to 1 or -1. Then, you can use this to display or not the 2 charts.

I hope that this .qvw will help you.

[Gysbert_Wassenaar]

Create a new variable vShow.

Add a Set Variable action to the first button to set variable vShow to value 1

Add a Set Variable action to the second button to set variable vShow to 0

In the first chart on the Layout tab add a conditional display expression: =vShow

In the second chart add a conditional display expression: =not vShow

[Aurelien_Martinez]

Hi,

1. Create one variable : vShow = 1

2. On first button in set variable action : not $(vShow) (for the vShow variable)

3. On one chart (properties => Layout => Show => Conditional => $(vShow))

(and on the other chart : not $(vShow))

[Anonymous]

Hi,

In order to do this you will have to do:

For the first button add 2 actions:

-minimize the second object (chart 2)

-restore the first object(chart 1)

For the second button add 2 actions:

-minimize the first object (chart 1)

-restore the second object(chart 2)

You will find the Object Id in Settings/Document Properties/ Sheets . Every Object has an object id, so find the ids for your charts and paste them in the Object Id field in the Button Actions Tab.

Hope it helps.

[#6]

In the Settings tab, go to variable overview and create a variable v1 and assign its value to 1

Create two Button objects say B1 and B2.

now in the Properties of Button object B1, go to action tab.

From There assign a action  set variable. in the variable name part, write the name of the variable i.e v1 and in the value part write 1.

And In the Properties of Button object B2, go to action tab.

From There assign a action  set variable. in the variable name part, write the name of the variable i.e v1 and in the value part write 0

Now in the Chart , go to Layout tab in the Properties of the Chart Object and check conditional show.

There write v1=1 for Chart1

and v1=0 for chart 2

This will help your cause.

Regards

Rishabh

[Aurelien_Martinez]

Or you can use Container 

[#8]

Thank you all for your help.It did work for 2 charts.Now what can I do if I have 8-10 charts?

Thank you again

[#9]

Thank you all for your help.It did work for 2 charts.Now what can I do if I have 8-10 charts?

Thank you again

[Anonymous]

If you use the method i suggested you need to make a button for each chart and for each button you need to minimize the rest of the chart and restore 1.

Hope it helps.