Adding an expression to Chart with a button???

[#1]

I have a chart that compares sales values for two locations. However for comparison I want to be able to add another expression that will show a total sales value for london, I only want to be able to see this if you click a button tho?? Is there a way to do this

I think maybe with the show value function and the use of a Variable, but I have no idea how to do this? any ideas please

[Gysbert_Wassenaar]

Use the button to set a variable and use the variable in the conditional display expression of the expression (QV11 needed though). See attached qvw.

[#3]

Thanks!

so ive created my variable, and created a button that sets the value of my variable to 1. what conditional expression do I use tho??

[#4 · Accepted solution]

Hi,

In the straight table, go to ->Properties->Presentation , select the column you want, and in the 'Conditional' text box, enter the variable name

Regards,

Anju

[#5]

Thanks all working