Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Shu
Contributor II
Contributor II

4th business day of the month

Hello, 

I'm trying to get a count of a field for all values after the 4th business day of the month. I think there's a way through NetWorkDays but I'm not entirely sure. Any help is greatly appreciated. 

 

Thanks,

Shu

1 Reply
sunny_talwar

May be this to determine the 4th business day of current month

=LastWorkDate(MonthStart(Today()), 4)

or 4th business day from a date field

=LastWorkDate(MonthStart(DateFieldName), 4)