topic Re: Network Days problem in QlikView

Network Days problem

Sun, 20 Mar 2016 08:11:07 GMT

Hi all,

I'm trying to calculate Network Days from one date to another, excluding Public Holidays.

In my example, I have a Start date of : 14/04/2015 and End Date :12/06/2015, with a Public Holiday of 08/06/2015

Using the expression : NetWorkDays(Appr,Auth,PublicHol) I get days of : 43, but when I calculate it manually I get 42, which is the correct answer. My client expects 42 and I calculate 42, not 43.

What am I doing wrong? - I've attached the sample .qvw - perhaps I'm missing something?

Many thanks!

Re: Network Days problem

rubenmarin — Sun, 20 Mar 2016 11:41:15 GMT

Hi coco, I count:

13 for apr

21 for may

9 for jun

Total: 43

Re: Network Days problem

Gysbert_Wassenaar — Sun, 20 Mar 2016 12:49:48 GMT

You or your calculator is wrong. Perhaps you're simply subtracting two dates and then subtracting the weekend days and the holiday. If that's the case you're not counting the last date as a day. The difference between two consecutive days is one, but they are still two days.

Re: Network Days problem

swuehl — Sun, 20 Mar 2016 13:20:17 GMT

As Gysbert already pointed out and as the HELP states:

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.

But I assume that's not your issue, otherwise you would have noticed the same issue with Ref B, right?

So, could you please clarify how you calculate what you defined as 'correct' value in more detailed steps?

On a side note, your current approach of defining public holidays per Ref will only work for a single public holiday per Ref, not for a list of holidays. Could this trigger (other) issues as well?

Re: Network Days problem

jagan — Mon, 21 Mar 2016 03:33:20 GMT

Hi,

Check this link

Master Calendar with Working days & Holidays Flag

Regards,

Jagan.