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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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.