Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use color() in the express

@sunny Talwar

Hi All,

    I want to add color () to the expression below, how do I go about it ?

IF([EXPERIENCE_RATING]=1,'NEGATIVE',

IF(([EXPERIENCE_RATING]=2 OR EXPERIENCE_RATING = 3),'NEUTRAL','POSITIVE'))

I want the bar chart to turn RED when it NEGATIVE, AMBER when it is NEUTRAL and GREEN when it is POSITIVE.

Thanks

1 Solution

Accepted Solutions
daniel_kusiak
Creator II
Creator II

Hi,

Change the background definition of your chart expression to:

IF(EXPERIENCE_RATING=1,Red(),IF(EXPERIENCE_RATING=2,Yellow(),Green()))

It should look like this:

If you want different colors use RGB function.

View solution in original post

2 Replies
daniel_kusiak
Creator II
Creator II

Hi,

Change the background definition of your chart expression to:

IF(EXPERIENCE_RATING=1,Red(),IF(EXPERIENCE_RATING=2,Yellow(),Green()))

It should look like this:

If you want different colors use RGB function.

Not applicable
Author

Thanks Daniel!!