need help

[qlikapple]

Hi team,

need help

i have date like this

my requirement is if currentdate is less than due date i need to show in back ground clor as red color

dimension of duedate  which is wriiten script  is

date(Date(Num#([Due Date]),'DD-MON-YYYY')) as DUEdate,

can anyoneplease  help

[Anonymous]

goto tab Dimension and click on "+" on your Dimension Duedate

Then open Background Color and define Expression like

if (Duedate < today(), red()

you Need to make sure that Duedate and today have the same date Format, if not use date function to bring them in same Format