Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
anonymous1
New 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
Contributor

Re: Expiry Date Expression

Your expression works for me.

see attached

2 Replies
olivetwist
Contributor

Re: Expiry Date Expression

Your expression works for me.

see attached

Support
Support

Re: Expiry Date Expression

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 don't forget to mark a correct resolution or answer to your problem or question as correct.