Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in business days

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

4 Replies
maxgro
MVP
MVP

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.

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

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

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

alexandros17
Partner - Champion III
Partner - Champion III

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

pratap6699
Creator
Creator

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