Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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 ?
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
Can you upload an example qlikview