Conditional Font colour in Axes on Chart

[#1]

Hi Guys

Building a Line chart , I want to add a conditional colour format, on the Y axis is a list of values -8000 to 5000, I wish for the values in minus range to be red , the others black.

I went into Chart props>Axes> selected Expressions font and clicked conditional, I put the following in

if([Losses Deff]<'1',RGB(255,0,0),RGB(0,0,0))

But all that did was change all my Y axis font BLACK

Can anyone please help ??

Thanks

[kji]

This expressions is calculated once for the whole chart, and not for each individual value. I dont think there is an easy way to achieve what you want.

[#3]

Hey Johan

But its just the actual font I want to apply the condition to , if the font is -8000 its red if its 1000 its black ,

Do you know if thats possible ?

[IAMDV]

Hi Mate,

Yes, Johan is right the expression is calculated once for the object and not for individual value. However, you can be little clever to load the color values within your load script and use them to highlight based on your requirement.

Cheers - DV

[#5]

Can you upload an example qlikview