topic Re: Exclude weekend days in QlikView https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501179#M686137 <HTML><HEAD></HEAD><BODY><P>=NetWorkDays(start_date,end_date) will return what you need</P></BODY></HTML> Mon, 13 Jan 2014 11:53:46 GMT Clever_Anjos 2014-01-13T11:53:46Z Exclude weekend days https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501177#M686135 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>For the record below I want to exclude the weekend days.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Customer</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>start date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>end days</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG># days (no weekend days)</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">a</TD><TD style="padding: 2px; text-align: center;">7-1-2014</TD><TD style="padding: 2px; text-align: center;">14-01-2014</TD><TD style="padding: 2px; text-align: center;">6</TD></TR></TBODY></TABLE><P></P><P>Is the an easy way to solve this issue?</P><P></P><P>Best regards,</P><P>Arjan</P></BODY></HTML> Mon, 13 Jan 2014 11:47:00 GMT https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501177#M686135 Anonymous 2014-01-13T11:47:00Z Re: Exclude weekend days https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501178#M686136 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try NetWorkDay() for this</P><P></P><P>=NetWorkDays('1/7/2014', '1/14/2014')</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 13 Jan 2014 11:52:03 GMT https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501178#M686136 jagan 2014-01-13T11:52:03Z Re: Exclude weekend days https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501179#M686137 <HTML><HEAD></HEAD><BODY><P>=NetWorkDays(start_date,end_date) will return what you need</P></BODY></HTML> Mon, 13 Jan 2014 11:53:46 GMT https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501179#M686137 Clever_Anjos 2014-01-13T11:53:46Z Re: Exclude weekend days https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501180#M686138 <HTML><HEAD></HEAD><BODY><P>jagan so can you please explain the netWorkDays () function in detail</P></BODY></HTML> Mon, 13 Jan 2014 11:55:32 GMT https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501180#M686138 sujeetsingh 2014-01-13T11:55:32Z Re: Exclude weekend days https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501181#M686140 <HTML><HEAD></HEAD><BODY><P>Hi Sujeet,</P><P></P><P>NetWorkdays() will receive Start and End date as parameters and returns the number of days between the two dates excluding Saturdays and Sundays.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 13 Jan 2014 11:58:31 GMT https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501181#M686140 jagan 2014-01-13T11:58:31Z Re: Exclude weekend days https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501182#M686142 <HTML><HEAD></HEAD><BODY><P class="syntax"><A name="kanchor523"></A><A name="networkdays"></A><SPAN class="Bold">networkdays (</SPAN><SPAN class="Italic">start:date, end_date {, holiday}</SPAN><SPAN class="Bold">)</SPAN> </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"></P><P class="example">Examples:</P><P><SPAN class="Code"><BR /></SPAN></P><P><SPAN class="Code">networkdays ('2007-02-19', '2007-03-01')</SPAN> returns 9&nbsp; </P><P><SPAN class="Code"><BR /></SPAN></P><P><SPAN class="Code">networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26')</SPAN> returns 8 </P></BODY></HTML> Mon, 13 Jan 2014 12:06:34 GMT https://community.qlik.com/t5/QlikView/Exclude-weekend-days/m-p/501182#M686142 MK_QSL 2014-01-13T12:06:34Z