Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 

need help

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

1 Reply
Not applicable

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