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