topic Issue in business days in QlikView

Issue in business days

Thu, 11 Jun 2015 14:48:35 GMT

Hi,

Can someone please help me with this issue.

Submitted Date - 06/02/2015
Decision Date - 06/04/2015

I want to calculate calendar days and business days

Calendar days = [Decision Date] - [Submitted Date]
It returned 2, which is correct

But for business days

I wrote the expression as, =NetWorkDays([Decision Date] , [Submitted Date])
I'm getting result as 0
But it should also be 2 right, since there are no holidays between June 2 and June 4

Thanks in advance.

Regards,
Sachin

Re: Issue in business days

maxgro — Thu, 11 Jun 2015 14:53:11 GMT

i get 3 (I have DD/MM/YYYY)

=NetWorkDays('02/06/2015', '04/06/2015')

try

NetWorkDays([Submitted Date], [Decision Date] )

from Qlik help

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.

Re: Issue in business days

fvelascog72 — Thu, 11 Jun 2015 14:53:17 GMT

Hi,

I think the expression should be Initial Date, Final Date:

=NetWorkDays([Submitted Date],[Decision Date])

Re: Issue in business days

alexandros17 — Thu, 11 Jun 2015 14:54:16 GMT

I think that the problem is due to date format ...

Re: Issue in business days

pratap6699 — Thu, 11 Jun 2015 15:22:21 GMT

=NetWorkDays([Submitted Date],[Decision Date],{optional for no of holydays})