topic Re: Adding an expression to Chart with a button??? in QlikView

Adding an expression to Chart with a button???

Thu, 20 Dec 2012 11:02:46 GMT

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

Re: Adding an expression to Chart with a button???

Gysbert_Wassenaar — Thu, 20 Dec 2012 11:09:45 GMT

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.

Re: Adding an expression to Chart with a button???

Thu, 20 Dec 2012 11:16:46 GMT

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??

Re: Adding an expression to Chart with a button???

Thu, 20 Dec 2012 11:25:09 GMT

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

Re: Adding an expression to Chart with a button???

Thu, 20 Dec 2012 11:27:51 GMT

Thanks all working