topic Chart: Make "Text on Data Point" invisible by condition doesn't work in QlikView

Chart: Make "Text on Data Point" invisible by condition doesn't work

guyvermeiren — Thu, 24 Feb 2011 13:28:47 GMT

Hello,

I have a linechart where I want to hide all results earlier than "Today's Monthnumber".

I selected "Text on Data Point" and it works fine if I use a condition for "Background Color" but not for "Text Color" (my text keeps appearing). (see example in enclosure)

When I switch to "Text on Axis" the condition for "Text Color" works perfect. (see also in enclosure)

I really would like to make this work with "Text on Data Point". Can anybody give me the solution to my problem.

Thanks.

Kind regards,

Guy

Chart: Make "Text on Data Point" invisible by condition doesn't work

Thu, 24 Feb 2011 14:42:53 GMT

Can you use the if-statement in the dimension? In this way also only the data from the current month will be displayed.

Chart: Make "Text on Data Point" invisible by condition doesn't work

guyvermeiren — Thu, 24 Feb 2011 14:48:37 GMT

Thanks,

We are using this (calculated dimension) as an alternative method but then the chart only shows the months as calculated in the dimension.

Kind regards,

Guy

Chart: Make "Text on Data Point" invisible by condition doesn't work

Anonymous — Thu, 24 Feb 2011 14:59:30 GMT

Hi Guy,

Did you check if both field have the same format?
The best way to check this is to make 2 text boxes

1.
=(Num(COPA.Period)

2.
=Num(Month(Today()))-1

This should return the same format, if not, that is the reason why it doesn't work.

Chart: Make "Text on Data Point" invisible by condition doesn't work

guyvermeiren — Thu, 24 Feb 2011 15:20:04 GMT

Hello Dennis,

They are both the same format, that's also the reason why the condition works for "Background Color" and also when use "Text on Axis".

There's really something strange going on.

Thanks anyway.

Kind regards,

Guy

Chart: Make "Text on Data Point" invisible by condition doesn't work

Thu, 24 Feb 2011 20:22:05 GMT

I'm using QV9 and the "Values on Data Point" with your condition on "Text Color" works as you expect.