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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NetworkDays

Hi everyone,

I would like to know how to calculate in a load script the number of days between a date lets say IssueDate and the current Date with the NewworkDays functions. Can anyone give me the syntax for doing this please.Thank you!!

1 Solution

Accepted Solutions
stephencredmond
Partner - Specialist II
Partner - Specialist II

Hi,

NetWorkDays(IssueDate, Today())

You can also add a list of holidays if you want to exclude them.

Did you check out the help file?  It has examples.

Regards,


Stephen

View solution in original post

2 Replies
stephencredmond
Partner - Specialist II
Partner - Specialist II

Hi,

NetWorkDays(IssueDate, Today())

You can also add a list of holidays if you want to exclude them.

Did you check out the help file?  It has examples.

Regards,


Stephen

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Syntax for network days.

     NetworkDays(startdate,enddate,[holidays])

     It calculates number of working days between startdate(should be less than the end date) and enddate,holiday dates is optional u can include it if needed.

Celambarasan