Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nurulizzaty
Contributor III
Contributor III

How to label status if the date is overdue or not

Hello experts,

I want to color the status of an incident. If the date of incident is already passed 3 days of current date,

then it is overdue (color as Red). If it is still below 3 days from the current date, it is colored as Green.

Please help me to code the query statement please....

Thank you in advance.

Regards,

Zety

1 Reply
Steven_Haught
Creator III
Creator III

If you are using a table chart you can try something like this in the background color formula expression:

= IF(incidentdate<=(Today()-3), 'Red', if(incidentdate<=Today() and incidentdate>today()-3, 'Green'))