Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Conditional Font colour in Axes on Chart

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

4 Replies
Employee
Employee

Conditional Font colour in Axes on Chart

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.

Not applicable

Conditional Font colour in Axes on Chart

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 ?

Luminary
Luminary

Re: Conditional Font colour in Axes on Chart

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

Not applicable

Re: Conditional Font colour in Axes on Chart

Can you upload an example qlikview

Community Browser