topic DURATION BY EXCLUDING WEEKDAYS AND HOLIDAYS in QlikView https://community.qlik.com/t5/QlikView/DURATION-BY-EXCLUDING-WEEKDAYS-AND-HOLIDAYS/m-p/754189#M268668 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>In My table i have REQUEST_NO ,REQUEST_START_DATE AND REQUEST_END_DATE .</P><P>By using Interval match function i calculated the DURATION to complete the REQUEST.</P><P>but i want to exclude the Weekdays from DURATION.&nbsp; in my case Friday and Saturday are weekdays (holidays) . Sunday is the first day of my week.</P><P>I tried Networkdays() function but i didn't succeed to achieve the desired result.</P><P></P><P>Kindly find the attached sample file,</P><P>please help me to solve the my problem.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Thu, 19 Mar 2015 20:18:39 GMT mdmukramali 2015-03-19T20:18:39Z DURATION BY EXCLUDING WEEKDAYS AND HOLIDAYS https://community.qlik.com/t5/QlikView/DURATION-BY-EXCLUDING-WEEKDAYS-AND-HOLIDAYS/m-p/754189#M268668 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>In My table i have REQUEST_NO ,REQUEST_START_DATE AND REQUEST_END_DATE .</P><P>By using Interval match function i calculated the DURATION to complete the REQUEST.</P><P>but i want to exclude the Weekdays from DURATION.&nbsp; in my case Friday and Saturday are weekdays (holidays) . Sunday is the first day of my week.</P><P>I tried Networkdays() function but i didn't succeed to achieve the desired result.</P><P></P><P>Kindly find the attached sample file,</P><P>please help me to solve the my problem.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Thu, 19 Mar 2015 20:18:39 GMT https://community.qlik.com/t5/QlikView/DURATION-BY-EXCLUDING-WEEKDAYS-AND-HOLIDAYS/m-p/754189#M268668 mdmukramali 2015-03-19T20:18:39Z Re: DURATION BY EXCLUDING WEEKDAYS AND HOLIDAYS https://community.qlik.com/t5/QlikView/DURATION-BY-EXCLUDING-WEEKDAYS-AND-HOLIDAYS/m-p/754190#M268669 <HTML><HEAD></HEAD><BODY><P>maybe with networkdays(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">REQUEST_START_DATE+1, REQUEST_END_DATE+1)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">+1 to adapt your weekdays (friday and saturday) to "standard" (saturday and sunday) weekdays&nbsp; </SPAN></P></BODY></HTML> Thu, 19 Mar 2015 21:01:23 GMT https://community.qlik.com/t5/QlikView/DURATION-BY-EXCLUDING-WEEKDAYS-AND-HOLIDAYS/m-p/754190#M268669 maxgro 2015-03-19T21:01:23Z