1 Reply Latest reply: Jul 2, 2014 10:04 AM by Robert Daitzman RSS

    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).