Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi David,
Try this was your expression:
if([Work Days Open] > 10, red(),white())
Thanks,
Sangram