topic NetWorkDays Function to include Saturday in QlikView https://community.qlik.com/t5/QlikView/NetWorkDays-Function-to-include-Saturday/m-p/697485#M676262 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>The NetWorkDays function in QlikView only considers Monday to Friday when calculating the difference between two dates.</P><P></P><P>I have been asked to include Saturday as a working day.</P><P></P><P>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.</P><P></P><P>NetWorkDays(%_CreatedOn, %_ScheduledOn)-1 as LeadTime</P><P></P><P>Has anyone included Saturdays in a similar calculation?&nbsp; How did you do it?</P><P></P><P>I have a calendar dimension that has a DayCount field (Monday to Friday is 1, Saturday and Sunday are 0).</P><P></P></BODY></HTML> Wed, 02 Jul 2014 14:02:15 GMT 2014-07-02T14:02:15Z NetWorkDays Function to include Saturday https://community.qlik.com/t5/QlikView/NetWorkDays-Function-to-include-Saturday/m-p/697485#M676262 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>The NetWorkDays function in QlikView only considers Monday to Friday when calculating the difference between two dates.</P><P></P><P>I have been asked to include Saturday as a working day.</P><P></P><P>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.</P><P></P><P>NetWorkDays(%_CreatedOn, %_ScheduledOn)-1 as LeadTime</P><P></P><P>Has anyone included Saturdays in a similar calculation?&nbsp; How did you do it?</P><P></P><P>I have a calendar dimension that has a DayCount field (Monday to Friday is 1, Saturday and Sunday are 0).</P><P></P></BODY></HTML> Wed, 02 Jul 2014 14:02:15 GMT https://community.qlik.com/t5/QlikView/NetWorkDays-Function-to-include-Saturday/m-p/697485#M676262 2014-07-02T14:02:15Z Re: NetWorkDays Function to include Saturday https://community.qlik.com/t5/QlikView/NetWorkDays-Function-to-include-Saturday/m-p/697486#M676263 <HTML><HEAD></HEAD><BODY><P>Heres a thread that may be of help to you</P><P></P><P><A href="https://community.qlik.com/message/53342">Network days with working saturday and holidays</A></P></BODY></HTML> Wed, 02 Jul 2014 14:04:39 GMT https://community.qlik.com/t5/QlikView/NetWorkDays-Function-to-include-Saturday/m-p/697486#M676263 2014-07-02T14:04:39Z