How to highlight cell in a specific colour

[#1]

Hello,

I have read multiple threads about cell highlighting certain colours, but the issue I am facing is actually writing the expression. I have a table with technology names and dates of when the technology will start its retire lifecycle and when it ends.

Eg.

TechnologyName	LifecyclePhase	Retire_StartDate	Retire_EndDate
SAN Switch	Retire	19/12/2013	07/10/2014
PowerEdge	Retire	15/11/2013	02/02/2014
Tapes	Legacy	05/03/2014	01/04/2014
Windows Server	Retire	07/10/2014	07/10/2016

When the Retire_EndDate is within 70 days or less from today, I want the background of the cell to highlight red, otherwise it will stay green. I've achieved this on different platforms using something something along the lines of "DateDiff("day",Date(DateTimeNow()),[Retire_EndDate])<70" However Qlikview does not accept DateDiff.

Can anyone help with the expression in how to do this and incorporate colour?

Many thanks.

[#2]

Thank you everyone for your feedback. I managed to get the colour working as expected. Really grateful!

Kind regards, Thuy

[kiranmanoharrode]

Hi Thuy,

Use following expression in background of Retire_EndDate Dimension. this will solve.

=if(Num(Today())-Num(Date(Retire_EndDate,'DD/MM/YYYY')>'70',Red(),Green())

Regards,
Kiran Rode

+91 8976977897