Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find missing day in last 7 days

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.

OR

suggest if this can be acheived with any other logic.

Thanks,

Deepa v

2 Replies
prieper
Master II
Master II

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

Not applicable
Author

Try below,

add dim in chart,

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

add exp ,

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