Calculate working days by only excluding holiday

[mohsinqlik]

Dear All,

I want to calculate working days by excluding holidays.

Qlik have Networkdays function to calcualte this but it excludes saturday and sunday along with holiday when calculating working days.But i want to calculate working days including weekends, it should consider saturday and sunday as a holiday only if it falls on holiday list.

I want to achieve this in script level i.e on back end.

Please find attached document

Regards,

Mohsin

[jonathandienst]

If you have a master calendar, then the best way to do this is to add a derived "working_day" field to the calendar that follows the rules you require (1 for work days, 0 for non-work days). Then it is simple to calculate the number of working days by just summing that field for the date range in question.

Offsets (FirstWorkDate / LastWorkDate) are slightly more difficult.