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
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nurulizzaty
Contributor III
Contributor III

How to add traffic light function into table

Hello experts,

How can i highlight if the date is over 3 days than the current date? Meaning it is overdue. I'm not sure how the formula is.

Eg : If(dimension: incident date) > 3 days after , then red circle is displayed.

Really need your help on this guys pleaseeeee :(((((

 

@Arthur_Fong help me pleasee 😞

Labels (2)
3 Replies
nurulizzaty
Contributor III
Contributor III
Author

Anyone help me on this please..... This is urgenttt :(((((((

@

Arthur_Fong
Partner
Partner

Do you have a sample app?

nurulizzaty
Contributor III
Contributor III
Author

I don't have the sample app but i can give you example. 

Eg: Dimension : Incident Date

So if the date has passed 3 days, it will turn out red, but if not it will turn green.

I tried this formula but obviously it is wrong. I don't know how to calculate the 3 days overdue..

if(incident_date >='3',lightRed(),lightgreen())