Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your expression works for me.
see attached
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