Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Color in an Expression

I have attached my first application in QlikSense.  I am trying to apply conditional formatting on the expression of Work Days Open.  I have tried everything and it does not seem to be working.  I need some help.  Here is what I have:

if([Work Days Open] >'10',Red(),White())

I want the background of [Work Days Open] to be Red if the value is greater than 10 otherwise White.

Let me know if there are any questions.

David

1 Solution

Accepted Solutions
brunobertels
Valued Contributor

Re: Color in an Expression

Hi David

replace your color expression by this one in the color by expression panel menu

your expression

//if([Work Days Open] >'10',Red(),Green())

mine

if(sum(If([NewStatus] = 'Open',(If([Work Days Open]<30,1,0)),0))>'10',lightRed(),Green())

if fact i took your mesure to evaluate the result > 10 in an if statement

you may have this

(then just adapt the color by expression mesure in all your mesure 30-60 , 60-90 etc

hope it helps

Bruno

2 Replies
brunobertels
Valued Contributor

Re: Color in an Expression

Hi David

replace your color expression by this one in the color by expression panel menu

your expression

//if([Work Days Open] >'10',Red(),Green())

mine

if(sum(If([NewStatus] = 'Open',(If([Work Days Open]<30,1,0)),0))>'10',lightRed(),Green())

if fact i took your mesure to evaluate the result > 10 in an if statement

you may have this

(then just adapt the color by expression mesure in all your mesure 30-60 , 60-90 etc

hope it helps

Bruno

reddys310
Honored Contributor II

Re: Color in an Expression

Hi David,

Try this was your expression:

if([Work Days Open] > 10, red(),white())

Thanks,

Sangram

Community Browser