Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.