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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

Background color help

Hi,

Can any one please help me to apply Red background color when its null.

I Have tried below expressions but none of them is working.

1. if(len(Trim(Status))>0,rgb(255,255,204),RGB(255,51,51))

2. if(len(Trim(Status))>0,rgb(255,255,204),

if(len(Trim(Status))<0 or isnull(Status) or Status='-',RGB(255,51,51)))

Please help me to fix the issue.

Thanks in advance

Null.png

2 Replies
suchit29
Partner - Contributor II
Partner - Contributor II

Try the below expression

if(isnull(Status) or Status='-',RGB(255,0,0))RGB.PNG

 

 
pawwy1415
Creator III
Creator III
Author

Hi @suchit29 

I have tried this solution but its not working.