Workday Number

Wed, 29 Jun 2011 16:12:54 GMT

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

Re: Workday Number

swuehl — Wed, 29 Jun 2011 16:23:45 GMT

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

topic Workday Number in QlikView

Workday Number

Re: Workday Number