topic Re: Change Weekend in NetWorkDays Function in App Development

Change Weekend in NetWorkDays Function

Anonymous — Tue, 06 Sep 2016 08:29:52 GMT

Hello everyone!

Is it possible to change the weekend of the function Networkdays by passing a parameter or something like that? Our weekend is Friday and Saturday, and the default of Qlik Sense is Saturday and Sunday. I tried changing FirstWeekDay to the following:

SET FirstWeekDay=6;

Also changed the Daynames but with no luck, Sunday gets excluded from the calculation.

I found a few solutions such as NetworkingDays(DateA+1, DateB+1) but it gives incorrect numbers.

Your help is appreciated!

Re: Change Weekend in NetWorkDays Function

swuehl — Tue, 06 Sep 2016 16:04:14 GMT

Could you post a sample where Networkdays(StartDate + 1, EndDate+1) returns incorrect numbers and what you expect to see instead?

Re: Change Weekend in NetWorkDays Function

Anonymous — Wed, 07 Sep 2016 03:50:49 GMT

Hey Stefan!

Using the function with the following days:

26-7-2015 and 28-7-2015 returns 3 instead of 2. Unless it calculates the start date as well?

Thanks Stefan!

Re: Change Weekend in NetWorkDays Function

swuehl — Wed, 07 Sep 2016 06:10:11 GMT

Yes, it does take both start and end date into account:

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

Hence, to exclude start date, add another +1 to this date.

Re: Change Weekend in NetWorkDays Function

Anonymous — Wed, 07 Sep 2016 06:28:07 GMT

Thanks Stefan,

Is it possible to return the time in minutes not days?

Re: Change Weekend in NetWorkDays Function

swuehl — Wed, 07 Sep 2016 18:46:44 GMT

A day has 24*60 minutes, so maybe just multiply by this number?

Re: Change Weekend in NetWorkDays Function

Anonymous — Thu, 08 Sep 2016 04:53:28 GMT

Thanks Stefan

My issue is what if the number returned is ZERO? as subtracting 1 will eliminate a full working day; in addition, even by not subtracting one, the result is kind of inaccurate as well (i.e. assuming an employee finishes a task within an hour, it will be calculated as a full working day and worse if the task goes to two different employees, Emp1 finished and then the task goes to Emp2 who also finished within the same day the function will calculate 2 working days instead of 1) That is why I was asking about actual minutes not converting days to minutes. By the way I am using the function at each step of an application history (Now I kind of think that it can not be used like this) and the reason is because I don't calculate steps where an application is returned to the applicant.

Wishing for your feedback!

Re: Change Weekend in NetWorkDays Function

swuehl — Thu, 08 Sep 2016 16:21:10 GMT

That's hard to answer without knowing the details of your data model.

Re: Change Weekend in NetWorkDays Function

SumitgargIBI — Wed, 27 Feb 2019 10:51:00 GMT

Can you please tell how to include Saturday in working days.