topic NetWorkDays function in expression in QlikView

NetWorkDays function in expression

ahmedwank — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

when i use NetWorkDays function in expression to calculate the difference of working days i always have 1 more.

for exemple in my table here bellow i should have 1 because there is only 1 day between monday and friday (whithout the weekend) and i have 2. That's the same story for all my dates, i have always 1 daye extra.

i don't understand why ?

Thanks for your help

Re: NetWorkDays function in expression

Vegar — Sat, 23 Mar 2019 17:46:24 GMT

The definition of the networkdays function is as follows:

The networkdays function returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holiday.

NetWorkdays for Friday-Monday will as designed return 2 days and not 1.

Re: NetWorkDays function in expression

Vegar — Sat, 23 Mar 2019 17:49:23 GMT

To get your desired no of days you could subtract one day.
=networkdays(start_date, end_date) -1

Read more about the function here: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunctions/networkdays.htm