Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
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'))