topic Re: Values On/Off for Chart in QlikView

Values On/Off for Chart

vcanale — Wed, 25 Nov 2020 16:16:04 GMT

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)

1^st expression for the Values OFF (Visible, Symbol and Line Off, Values on Data Points Deactivated)

2^nd 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?

Re: Values On/Off for Chart

Clever_Anjos — Wed, 22 Jun 2016 15:16:06 GMT

Which version do you use?

Why don´t you just disable the expression using "Conditional"?

Re: Values On/Off for Chart

Clever_Anjos — Wed, 22 Jun 2016 15:17:17 GMT

Re: Values On/Off for Chart

vcanale — Wed, 22 Jun 2016 16:10:31 GMT

I'm using QV10 and unfortunately the "Conditional" option is not available in QV10.

Thanks for your help

Re: Values On/Off for Chart

Clever_Anjos — Wed, 22 Jun 2016 16:33:57 GMT

Is an upgrade out of question?

Re: Values On/Off for Chart

stigchel — Wed, 22 Jun 2016 16:40:48 GMT

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

Re: Values On/Off for Chart

stigchel — Wed, 22 Jun 2016 16:48:34 GMT

And a screenshot

Re: Values On/Off for Chart

vcanale — Thu, 23 Jun 2016 09:25:43 GMT

yes for the moment! ..thx!

Re: Values On/Off for Chart

vcanale — Thu, 23 Jun 2016 09:44:48 GMT

Hi Piet,
It works perfectly!..
Great solution.. and using one expression only! (Invisible option unchecked)
Thanks a lot for your help!

Re: Values On/Off for Chart

stigchel — Thu, 23 Jun 2016 11:59:10 GMT

You're welcome, glad to be of help