topic Counts excluding Non-Business Days in QlikView https://community.qlik.com/t5/QlikView/Counts-excluding-Non-Business-Days/m-p/1330550#M411052 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to generate counts or records that have a 'Return Date' within 2 <SPAN style="text-decoration: underline;"><STRONG>business days</STRONG></SPAN> of 'CheckOut Date' for any given Saturday to Friday week range. I am looking for some efficient way to do this by taking into account weekends and e.g. US holidays for a given year. E.g. a book checkout on a Friday is 2-business days old on Tuesday and so on. I have attached sample data for experimentation purposes.</P><P></P><P>Thank you,</P><P>Sokol</P></BODY></HTML> Mon, 17 Apr 2017 21:04:44 GMT spetushi 2017-04-17T21:04:44Z Counts excluding Non-Business Days https://community.qlik.com/t5/QlikView/Counts-excluding-Non-Business-Days/m-p/1330550#M411052 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to generate counts or records that have a 'Return Date' within 2 <SPAN style="text-decoration: underline;"><STRONG>business days</STRONG></SPAN> of 'CheckOut Date' for any given Saturday to Friday week range. I am looking for some efficient way to do this by taking into account weekends and e.g. US holidays for a given year. E.g. a book checkout on a Friday is 2-business days old on Tuesday and so on. I have attached sample data for experimentation purposes.</P><P></P><P>Thank you,</P><P>Sokol</P></BODY></HTML> Mon, 17 Apr 2017 21:04:44 GMT https://community.qlik.com/t5/QlikView/Counts-excluding-Non-Business-Days/m-p/1330550#M411052 spetushi 2017-04-17T21:04:44Z Re: Counts excluding Non-Business Days https://community.qlik.com/t5/QlikView/Counts-excluding-Non-Business-Days/m-p/1330551#M411053 <HTML><HEAD></HEAD><BODY><P>Have you looked into Networkdays() function?</P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/networkdays.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/networkdays.htm">networkdays ‒ QlikView</A></P></BODY></HTML> Mon, 17 Apr 2017 21:07:51 GMT https://community.qlik.com/t5/QlikView/Counts-excluding-Non-Business-Days/m-p/1330551#M411053 swuehl 2017-04-17T21:07:51Z Re: Counts excluding Non-Business Days https://community.qlik.com/t5/QlikView/Counts-excluding-Non-Business-Days/m-p/1330552#M411054 <HTML><HEAD></HEAD><BODY><P>Thanks Stefan. I haven't used this function in the past.</P><P>I looked at it and it should do the job.</P></BODY></HTML> Tue, 18 Apr 2017 12:14:08 GMT https://community.qlik.com/t5/QlikView/Counts-excluding-Non-Business-Days/m-p/1330552#M411054 spetushi 2017-04-18T12:14:08Z