Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
solomonadjei
Contributor III
Contributor III

IF EXPRESSION

Happy New year everyone, I hope everyone had a good time.

 

Could someone please advise what am I doing wrong in the below expression.

if([Trust Spend] = "Actual Trust Spend",Green(), Red())

 

The “Actual Trust Spend” is a label not a field name and I keep getting : RGB(0,128,0) as an answer.  

10 Replies
solomonadjei
Contributor III
Contributor III
Author

Thanks very much Sunny, it worked 🙂