topic Re: Conditional Font colour in Axes on Chart in QlikView

Conditional Font colour in Axes on Chart

Tue, 14 Jun 2011 12:43:53 GMT

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

Conditional Font colour in Axes on Chart

kji — Tue, 14 Jun 2011 13:06:12 GMT

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.

Conditional Font colour in Axes on Chart

Tue, 14 Jun 2011 13:09:03 GMT

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 ?

Re: Conditional Font colour in Axes on Chart

IAMDV — Tue, 14 Jun 2011 14:27:29 GMT

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

Re: Conditional Font colour in Axes on Chart

Fri, 06 Sep 2013 13:35:12 GMT

Can you upload an example qlikview