Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a chart with an available option to switch ON and OFF the Values on Data Points
To do it I have 2 expressions in the Chart Properties (Same expression but the second with a condition to activate the Values on Data Points)
1st expression for the Values OFF (Visible, Symbol and Line Off, Values on Data Points Deactivated)
2nd expression for the Values ON (Invisible, Symbol and Line Off, Values on Data Points Activated)
When the Values are set on ON everything looks good, but when on OFF I have the “– “appearing on the chart instead of nothing:
Note: there is a condition to return “Data 1” only for specific selections.
If I add any “else” to the condition, eg: IF(Values='On', $(vExpressionChart), ' ')
The null symbol on the chart disappear and the Line for Data 1 only is fine (and this is what I want!), but the legend lists all the Data instead of Only Data 1.
Any idea on how can I fix this?
And a screenshot
Which version do you use?
Why don´t you just disable the expression using "Conditional"?
I'm using QV10 and unfortunately the "Conditional" option is not available in QV10.
Thanks for your help
Is an upgrade out of question?
Instead of using the condition in the expression, use it for the text color attribute(Click on the plus sign before the expression to expand) of the expression and use
=If(Values='On',rgb(0,0,0),argb(0,0,0,0))
and use the the normal expression for calculating the values, they will become invisible when the show values option is set to off.
One thing I noticed testing this was that in my version the text color attribute did not function when the display line property for this expression was not on. If so turn the line property on, it wont be visible because you set that property to off anyway
And a screenshot
yes for the moment! ..thx!
Hi Piet,
It works perfectly!..
Great solution.. and using one expression only! (Invisible option unchecked)
Thanks a lot for your help!
You're welcome, glad to be of help