Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Contributor II

Re: How to use color() in the express

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.

2 Replies
daniel_kusiak
Contributor II

Re: How to use color() in the express

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

Re: How to use color() in the express

Thanks Daniel!!

Community Browser