Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Change text colour based on value

Hi, 

I have a straight chart where i want the values to change colour dependant on the value.

There are three possible values; Early, On Time and Late

I'm currently using this expression within the 'Text Color' element of the expression: 

=if(Finish='On Time',Green(),RGB(255,0,0))

Which is only allowing me to have the On Time values to show as green with everything else red.

Ideally i'd like the following value/colour matches:

On Time - Blue

Early - Green

Late - Red

I'm presuming i need some sort of dual If statement but i can't quite seem to fix it.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Pick(Match(Finish,'On Time','Early','Late'),Blue(),Green(),Red())

 

Regards,

Girish.

View solution in original post

2 Replies
Highlighted
Partner
Partner

Pick(Match(Finish,'On Time','Early','Late'),Blue(),Green(),Red())

 

Regards,

Girish.

View solution in original post

Highlighted
Creator II
Creator II

Fantastic, 

Thank you!