topic Make text on data points invisible in QlikView

Make text on data points invisible

guyvermeiren — Mon, 21 Feb 2011 11:01:23 GMT

Hello,

I have a linechart where I want to make the text on a conditonal number of datapoints invisble.

For the line I already did this by using conditional "Background Color" by using (see also example)

if(Num(COPA.Period)<=Num(Month(Today()))-1,Black(255),White())

Can I do the same for making the text on the datapoints disappear ??

Thanks.

Best regards,

Guy

prieper — Mon, 21 Feb 2011 11:09:04 GMT

If you open the "+" below the expression, there is a field called "Show Value", where you may enter a condition.

HTH
Peter

guyvermeiren — Mon, 21 Feb 2011 11:23:01 GMT

Thanks Peter,

Can you give me an idea of what type of condition I have to use ??

Best regards,

Guy

prieper — Mon, 21 Feb 2011 11:59:27 GMT

Which entries do you wish to maintain? Can you post an example?

Peter

guyvermeiren — Mon, 21 Feb 2011 13:44:08 GMT

Thanks Peter,

I already solved the problem in this way:

I used "Text Color" with condition: =if(Num(COPA.Period)<=Num(Month(Today()))-1,Black(255),White())

In this way I only get (see) the result for the "Months" (number) lower than today.

Best regards,

Guy

guyvermeiren — Tue, 22 Feb 2011 14:18:13 GMT

Help,

There are strange things happening. Yesterday it worked as I said in my former message. Today still no result.

However, if I make the choice "Text on Axis" all the formats work. I can make the text any color or invisible by using the condition

=if(Num(COPA.Period)<=Num(Month(Today()))-1,black(255),white(255)) for "Text Color"

Why doesn't this work for the option "Text on Datapoint" ?? Is there a bug in version 9.00 SR3 or 4 ??

Thanks,

Guy