Help me in hiding the chart?

[durgabhavani]

Hi All,

I have one text object with one bulb. It has four statuses.

1. no color
2. green
3. red
4. orange

Now by default it has No color  --- at this point my barchart needs to be hidden.
suppose if bulb color changed to green or red or orange, Now i need to click on the bulb and then i need to display the hidden chart.

Please help me in writing trigger or in some other way to hide and display the object.

Thanks,
durga

[awhitfield · Accepted solution]

Hi Durga,

1. create a variable e.g v_ShowChart, with a definition of 0

2. on the bulb text object, add an action - External>SetVariable, add the above variable and set the value to =if(v_ShowChart =1,0,1)

3. On the Barchart - Layout - show > add the condition, =v_ShowChart=1

Andy

[ankitaag]

Hi Durga,

In the Layout tab of Chart properties..

write the conditional expression under show section as

=if(GetFieldSelections(Date)>0,1,0)

[durgabhavani]

@Andrew

Great! its working!.

it is working based on text object what i expected! Nice!

Suppose if click on clear selections text object in my dashboard it is displaying the barchart in current status.

but i want to hidden bar chart displaying when i click on clear selections.  Please Advice!

@ Ankitha

it is working but without clicking on the bulb it is display barchart! but clicking on clear selections barchart is hiding what i am expecting!

Thanks,

Durga

[ankitaag]

Lol! you want to combine these 2 solutions

[awhitfield]

Hi Durga,

If you click on the text box a second time, the chart will hide again

Andy

[ankitaag]

Yes I tried implementing it..

The only problem is when I clear the selections I have to again click the button to hide the chart, it doesnt hide automatically

[awhitfield]

OK, easy way is to create your own clear selections button that both clears selections and also resets the variable to 0 again.

Andy

[ankitaag]

hmm..will try that