Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background Color Expression

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

4 Replies
Not applicable
Author

Crrect expression

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

MK_QSL
MVP
MVP

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

MK_QSL
MVP
MVP

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

Not applicable
Author

Thank you it worked.