topic Re: Networkdays Function in QlikView

Networkdays Function

Tue, 22 Dec 2015 22:10:31 GMT

So I want to create an expression that calculates the network days for the month that I select. So I select december, it will give me 16 days as it is 12/1 to 12/22 and there is 16 network days so far. So for November, it would calculate the number of network days in November.

Hope this makes sense.

Re: Networkdays Function

maxgro — Tue, 22 Dec 2015 23:39:54 GMT

if you have a date field d you can try with the monthstart and monthend function

NetWorkDays(MonthStart(Max(d)), MonthEnd(Max(d)))

Re: Networkdays Function

MarcoWedel — Tue, 22 Dec 2015 23:44:43 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Re: Networkdays Function

Wed, 23 Dec 2015 17:01:57 GMT

Thank you Marco. This is very helpful. So I am assuming this accounts for all US federal holidays?

Simon

Re: Networkdays Function

MarcoWedel — Wed, 23 Dec 2015 23:12:07 GMT

No, holidays have to be defined as additional parameter(s) in the NetWorkDays() function.

regards

Marco

Re: Networkdays Function

Wed, 23 Dec 2015 23:13:30 GMT

How do I define holidays in the function?

Re: Networkdays Function

maxgro — Thu, 24 Dec 2015 13:23:51 GMT

this is from QlikView help; as Marco said, holydays are additional parameters

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8

Find Net Working Days