Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Anonymous
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