topic Re: Need help in Net Working Days in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368585#M137019 <HTML><HEAD></HEAD><BODY><P>Hi Chris,</P><P></P><P>Have you tried the NetWorkDays() function?</P></BODY></HTML> Thu, 26 Jul 2012 07:02:44 GMT Anonymous 2012-07-26T07:02:44Z Need help in Net Working Days https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368583#M137017 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>As I need to find the net working days of (RelDate), Saturday and Sunday will be holiday from the period of Oct 2011 to Sep 2012.</P><P></P><P>Can anybody help me...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Thu, 26 Jul 2012 07:00:11 GMT https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368583#M137017 2012-07-26T07:00:11Z Re: Need help in Net Working Days https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368584#M137018 <HTML><HEAD></HEAD><BODY><P>Hi Chriss,</P><P></P><P class="syntax"><SPAN class="Bold">Function Networkdays (</SPAN><SPAN class="Italic">start:date, end_date {, holiday}</SPAN><SPAN class="Bold">)</SPAN>&nbsp; will do this job.</P><P class="syntax"></P><P>Returns the number of working days (Monday-Friday) between and including <SPAN class="Italic">start_date</SPAN> and <SPAN class="Italic">end_date</SPAN> taking into account any optionally listed <SPAN class="Italic">holidays</SPAN>. All parameters should be valid dates or timestamps. </P><P class="example">Examples:</P><P><SPAN class="Code">networkdays ('2007-02-19', '2007-03-01')</SPAN> returns 9&nbsp; </P><P><SPAN class="Code">networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26')</SPAN> returns 8</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Thu, 26 Jul 2012 07:02:44 GMT https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368584#M137018 Sokkorn 2012-07-26T07:02:44Z Re: Need help in Net Working Days https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368585#M137019 <HTML><HEAD></HEAD><BODY><P>Hi Chris,</P><P></P><P>Have you tried the NetWorkDays() function?</P></BODY></HTML> Thu, 26 Jul 2012 07:02:44 GMT https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368585#M137019 Anonymous 2012-07-26T07:02:44Z Re: Need help in Net Working Days https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368586#M137020 <HTML><HEAD></HEAD><BODY><P>Hello&nbsp; Sokkorn and Johannes,</P><P></P><P>Thanks a lot.... its working fine..</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Thu, 26 Jul 2012 07:29:30 GMT https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368586#M137020 2012-07-26T07:29:30Z Re: Need help in Net Working Days https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368587#M137021 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>This one is helpfull for you.</P><P></P><P></P><P>Regards</P><P>Rajni.</P></BODY></HTML> Thu, 26 Jul 2012 09:27:17 GMT https://community.qlik.com/t5/QlikView/Need-help-in-Net-Working-Days/m-p/368587#M137021 rajni_batra 2012-07-26T09:27:17Z