Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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
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
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

Not applicable

Thanks Daniel!!