topic Re: Expiry Date Expression in QlikView

Expiry Date Expression

anonymous1 — Sat, 16 Nov 2024 03:02:02 GMT

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

Re: Expiry Date Expression

olivetwist — Thu, 11 Jul 2019 12:46:18 GMT

Your expression works for me.

see attached

Re: Expiry Date Expression

Brett_Bleess — Tue, 06 Aug 2019 13:37:26 GMT

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