Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!!