Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Reply
MVP
MVP

Re: Workday Number

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

Community Browser