topic Re: holidays in QlikView https://community.qlik.com/t5/QlikView/holidays/m-p/328438#M1195796 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>&nbsp;&nbsp; Have a look at this example. You will find this in help of qlikview.</P><P></P><P></P><H4 style="background-color: #c0c0c0;">networkdays<A name="kanchor523"></A><A name="networkdays"></A> ( <SPAN style="font-style: italic;">start:date, end_date {, holiday}</SPAN> )</H4><P>Returns the number of working days (Monday-Friday) between and including <SPAN style="font-style: italic;">start_date</SPAN> and <SPAN style="font-style: italic;">end_date</SPAN> taking into account any optionally listed <SPAN style="font-style: italic;">holidays</SPAN>. All parameters should be valid dates or timestamps.</P><H2>Examples:</H2><P><SPAN class="Bold">networkdays</SPAN> ('2007-02-19', '2007-03-01') returns 9&nbsp; </P><P><SPAN class="Bold">networkdays</SPAN> ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8&nbsp; </P><P></P><P></P><P>Using this you will get the no. of working days..</P><P></P><P>To get non working days you can do this ( count the total days - working days.)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 29 Jun 2011 07:53:53 GMT kaushiknsolanki 2011-06-29T07:53:53Z holidays https://community.qlik.com/t5/QlikView/holidays/m-p/328437#M1195795 <HTML><HEAD></HEAD><BODY><P>Hello everybody, I'm marco and i'm from Italy.</P><P>I have a big problem.</P><P><SPAN id="result_box" lang="en"><SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">Someone</SPAN> <SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">knows a</SPAN> <SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">function that</SPAN> <SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">returns me</SPAN> <SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">the number of</SPAN> <SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">non-working days</SPAN> <SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">(Sat</SPAN><SPAN title="Fai clic per visualizzare le traduzioni alternative">, Sun</SPAN><SPAN title="Fai clic per visualizzare le traduzioni alternative">) between two</SPAN> <SPAN class="hps" title="Fai clic per visualizzare le traduzioni alternative">dates</SPAN><SPAN title="Fai clic per visualizzare le traduzioni alternative">?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN title="Fai clic per visualizzare le traduzioni alternative">thank you</SPAN></SPAN></P></BODY></HTML> Wed, 29 Jun 2011 07:40:26 GMT https://community.qlik.com/t5/QlikView/holidays/m-p/328437#M1195795 2011-06-29T07:40:26Z Re: holidays https://community.qlik.com/t5/QlikView/holidays/m-p/328438#M1195796 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>&nbsp;&nbsp; Have a look at this example. You will find this in help of qlikview.</P><P></P><P></P><H4 style="background-color: #c0c0c0;">networkdays<A name="kanchor523"></A><A name="networkdays"></A> ( <SPAN style="font-style: italic;">start:date, end_date {, holiday}</SPAN> )</H4><P>Returns the number of working days (Monday-Friday) between and including <SPAN style="font-style: italic;">start_date</SPAN> and <SPAN style="font-style: italic;">end_date</SPAN> taking into account any optionally listed <SPAN style="font-style: italic;">holidays</SPAN>. All parameters should be valid dates or timestamps.</P><H2>Examples:</H2><P><SPAN class="Bold">networkdays</SPAN> ('2007-02-19', '2007-03-01') returns 9&nbsp; </P><P><SPAN class="Bold">networkdays</SPAN> ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8&nbsp; </P><P></P><P></P><P>Using this you will get the no. of working days..</P><P></P><P>To get non working days you can do this ( count the total days - working days.)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 29 Jun 2011 07:53:53 GMT https://community.qlik.com/t5/QlikView/holidays/m-p/328438#M1195796 kaushiknsolanki 2011-06-29T07:53:53Z