topic Chart Expression conditionally Show value in QlikView

Chart Expression conditionally Show value

Thu, 05 Sep 2013 22:18:04 GMT

Hello All,

I am working on an application to show data points on the chart conditionally. i.e. if myField is not numeric (i.e. max(myField) is Null) then the dual value of the data point must show up.

I have an expression:

=if(TesterTypeVersion = 'MyTestVersion', if(IsNull(max(myField)),Dual('AlternateText',-120), max(myField)))

Dimensions used:

Frequency.

I am assigning the dual value of "AlternateText" if my expression evaluates to null.

The issue am facing is: If I choose the "Show Value" Attribute Expression and give the definition for it as =max(myField) = Null(), it shows up the value of "-120" instead of the dual value of "AlternateText". However if I check the box - Values on datapoints at the bottom of the expressions tab, then the dual representation is shown along with all the other datapoints value on the graph. I would like to see only the data point value of AlternateText.

I have the "Plot Values inside the segment" checkbox checked under the Presentation tab. Is there anything that I am missing?

Or is there an alternate way to achieve the same?

Re: Chart Expression conditionally Show value

rwunderlich — Fri, 06 Sep 2013 00:03:05 GMT

If I understand your question correctly, it works for me with just a "Show Value" attribute expression. See attached and tell me if it works for you. Could be a version bug.

-Rob

http://masterssummit.com

http://robwunderlich.com