topic calculation only with workdate in QlikView https://community.qlik.com/t5/QlikView/calculation-only-with-workdate/m-p/1186256#M462460 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>at the moment I have the problem that I want to calculate our deliveryquote.</P><P></P><P>My biggest problem is, when we get new orders on friday, we have no chance to deliver this order on Monday, but</P><P>in calculation I say order date - delivery date and there I get 3 days, but we have deliverd it at 1 day.</P><P></P><P>So have I any chance to say, that I only want to calculate with the workdate?</P><P></P><P>Thanks a lot of help</P><P></P><P>Best regards</P><P></P><P>Björn</P></BODY></HTML> Fri, 16 Sep 2016 09:06:49 GMT 2016-09-16T09:06:49Z calculation only with workdate https://community.qlik.com/t5/QlikView/calculation-only-with-workdate/m-p/1186256#M462460 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>at the moment I have the problem that I want to calculate our deliveryquote.</P><P></P><P>My biggest problem is, when we get new orders on friday, we have no chance to deliver this order on Monday, but</P><P>in calculation I say order date - delivery date and there I get 3 days, but we have deliverd it at 1 day.</P><P></P><P>So have I any chance to say, that I only want to calculate with the workdate?</P><P></P><P>Thanks a lot of help</P><P></P><P>Best regards</P><P></P><P>Björn</P></BODY></HTML> Fri, 16 Sep 2016 09:06:49 GMT https://community.qlik.com/t5/QlikView/calculation-only-with-workdate/m-p/1186256#M462460 2016-09-16T09:06:49Z Re: calculation only with workdate https://community.qlik.com/t5/QlikView/calculation-only-with-workdate/m-p/1186257#M462461 <HTML><HEAD></HEAD><BODY><P><STRONG>Would you provide Excel and expected o/p</STRONG></P></BODY></HTML> Fri, 16 Sep 2016 16:16:21 GMT https://community.qlik.com/t5/QlikView/calculation-only-with-workdate/m-p/1186257#M462461 Anil_Babu_Samineni 2016-09-16T16:16:21Z Re: calculation only with workdate https://community.qlik.com/t5/QlikView/calculation-only-with-workdate/m-p/1186258#M462462 <HTML><HEAD></HEAD><BODY><P>May be using NetWorkDays() function</P><P><A href="http://www.learnqlickview.com/qlikview-functions-networkdays/" title="http://www.learnqlickview.com/qlikview-functions-networkdays/">http://www.learnqlickview.com/qlikview-functions-networkdays/</A></P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/networkdays.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/networkdays.htm">networkdays ‒ QlikView</A></P></BODY></HTML> Fri, 16 Sep 2016 16:16:57 GMT https://community.qlik.com/t5/QlikView/calculation-only-with-workdate/m-p/1186258#M462462 sunny_talwar 2016-09-16T16:16:57Z