topic Re: Background Color Expression in QlikView

Background Color Expression

Mon, 21 Apr 2014 16:30:41 GMT

Hello,

Can someone tell me what's wrong with the following expression:

if([Test] < '3', green(), if([Overall Risk Value] >= 3 and <= 5.5, Yellow(), Red()))

Thanks in Advance,

-Lenny

Mon, 21 Apr 2014 16:31:43 GMT

Crrect expression

if([Test] < '3', green(), if([Test] >= 3 and <= 5.5, Yellow(), Red()))

MK_QSL — Mon, 21 Apr 2014 16:31:48 GMT

if([Test] < '3', green(), if([Overall Risk Value] >= 3 and [Overall Risk Value] <= 5.5, Yellow(), Red()))

MK_QSL — Mon, 21 Apr 2014 16:32:29 GMT

if([Test] < '3', green(), if([Test] >= 3 and [Test]<= 5.5, Yellow(), Red()))

Mon, 21 Apr 2014 16:35:25 GMT

Thank you it worked.