topic Re: conditional formatting in QlikView

conditional formatting

samuel_brierley — Thu, 05 Sep 2013 14:25:28 GMT

if(reloadtime()=today()

can someone see whats wrong with the above expression/

rustyfishbones — Thu, 05 Sep 2013 14:30:41 GMT

you are missing ) at the end

So something like

IF(ReloadTime()=TODAY(),GREEN(),RED())

Anonymous — Thu, 05 Sep 2013 14:30:48 GMT

Samuel

reloadtime() returns a datetime, whereas today() returns just a date.

So use :

if ( date(floor(reloadtime())) =today() ..................

Which converts reloadtime() to a pure date.

Best Regards, Bill Markham

Thu, 05 Sep 2013 14:30:49 GMT

reloadTime() return the day AND the time the document was reloaded, and today() return only todays day. You should better use:

Date(Floor(ReloadTime()))=today()

jpapador — Thu, 05 Sep 2013 14:31:16 GMT

My guess would be that reloadtime() is a time stamp and Today() is just a date. Use the date function to get them into the same format.

If(Date(Floor(ReloadTime()), 'M/DD/YYYY') = Date(Floor(Today()), 'M/DD/YYYY'), <Condition Here>)