Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

NetWorkDays Function to include Saturday

Hi all

The NetWorkDays function in QlikView only considers Monday to Friday when calculating the difference between two dates.

I have been asked to include Saturday as a working day.

I calculate the lead time for an activity in the script of my QlikView report (see below) so that I can then use Median(LeadTime) in the Pivot Table in my report.

NetWorkDays(%_CreatedOn, %_ScheduledOn)-1 as LeadTime

Has anyone included Saturdays in a similar calculation?  How did you do it?

I have a calendar dimension that has a DayCount field (Monday to Friday is 1, Saturday and Sunday are 0).

1 Reply
Not applicable

Re: NetWorkDays Function to include Saturday

Heres a thread that may be of help to you

Network days with working saturday and holidays

Community Browser