Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thank you everyone for your feedback. I managed to get the colour working as expected. Really grateful!
Kind regards, Thuy
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