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: 
anonymous1
Contributor III
Contributor III

Expiry Date Expression

hi, 

im creating a table with a  list of items and their dates.  I need all the dates before today (expired dates), and dates within the next 2 months (upcoming expiry dates), to appear in Red in the table.  I can't seem to get my expression to work for upcoming expiry dates:

if ([ITEM_DATE]<=Today()+60, Red())

however it works for the already expired dates:

if ([ITEM_DATE]<=Today(), Red())

all advice appreciated

 

Labels (3)
1 Solution

Accepted Solutions
olivetwist
Creator
Creator

Your expression works for me.

see attached

View solution in original post

2 Replies
olivetwist
Creator
Creator

Your expression works for me.

see attached

Brett_Bleess
Former Employee
Former Employee

Did Olivetwist's post help you resolve things?   If so, be sure to click the Accept as Solution button on the post to give them credit for helping you out.  If you still require further assistance, please update with further information.

Here are some Design Blog posts that may be somewhat useful as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

https://community.qlik.com/t5/Qlik-Design-Blog/Using-RGB-and-ARGB-to-define-colors/ba-p/1464387

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.