topic Re: Find missing day in last 7 days in QlikView

Find missing day in last 7 days

Wed, 28 Jan 2015 09:02:32 GMT

Hello,

I have a datetime column,

I want to check, if some date is missing in the last 7 days.

So, I was trying to compare today()-7 = 7th top value, please suggest how can i get it.

suggest if this can be acheived with any other logic.

Thanks,

Deepa v

prieper — Wed, 28 Jan 2015 09:38:02 GMT

You may count the number of (DISTINCT) records after TODAY() - 7.

Else have a mastercalendar with all days and check the JOIN for blank fields

HTH Peter

Wed, 28 Jan 2015 10:36:59 GMT

Try below,

add dim in chart,

=aggr(only({<StartDate={">=$(=max(StartDate)-7)"}>}StartDate),StartDate)

add exp ,

=if(isnull(StartDate),'Null','YES')