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

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
Master
Master

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

View solution in original post

2 Replies
brunobertels
Master
Master

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

reddy-s
Master II
Master II

Hi David,

Try this was your expression:

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

Thanks,

Sangram