Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.