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

Workday Number

I need to be able to determine in my load script the number associated with a workday where a workday is equal to a weekday excluding holidays.  I can load (externally) the holiday dates.  The real question is determining the workday number.  For example, if the 1st of the month falls on a Sunday, Monday would be my first workday so it should be the first workday, tuesday should be the 2nd workday, next monday would be the 6th workday and so on.  The goal is to be able to compare say the first 10 working days for every month.

Thanks,

Kevin

1 Reply
swuehl
MVP
MVP

Hi kkelly,

maybe you could use function networkdays(start:date, end_date{,holiday})

with start:date eq. MonthsStart(DATE), end_date eq. DATE and your imported list added.

Regards,

Stefan