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

Announcements
Join us in Bucharest on Sept 18th 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