topic Re: Within last 7 days in QlikView

Within last 7 days

Thu, 08 Oct 2015 10:15:20 GMT

I need some text changed to red if the Ideas.CalendarDate is within the last 7 days

I don't think this is right though. Any ideas?

IF(Today()-Ideas.CalendarDate<'8',RGB(255,0,0),)

Re: Within last 7 days

rubenmarin — Thu, 08 Oct 2015 10:21:31 GMT

Hi Alex, you should remove the last comma, and numbers doesn't need to be between simple quotes:

IF(Today()-Ideas.CalendarDate<8,RGB(255,0,0))

It will only work where there is only one value for Ideas.CalendarDate, if ther are more than one value you'll need some kind of aggregation to return only one value, ie:

IF(Today()-Max(Ideas.CalendarDate)<8,RGB(255,0,0))

Re: Within last 7 days

Thu, 08 Oct 2015 10:29:44 GMT

if(Ideas.CalendarDate >=Date(Today()-7) and Ideas.CalendarDate <=Date(Today()),RGB(255,0,0))