Solved: calculation only with workdate - Qlik Community

Report Inappropriate Content · ‎2016-09-16

Dear all,

at the moment I have the problem that I want to calculate our deliveryquote.

My biggest problem is, when we get new orders on friday, we have no chance to deliver this order on Monday, but

in calculation I say order date - delivery date and there I get 3 days, but we have deliverd it at 1 day.

So have I any chance to say, that I only want to calculate with the workdate?

Thanks a lot of help

Best regards

Björn

Anil_Babu_Samineni · ‎2016-09-16

Would you provide Excel and expected o/p

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2016-09-16

Would you provide Excel and expected o/p

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2016-09-16

May be using NetWorkDays() function

http://www.learnqlickview.com/qlikview-functions-networkdays/

networkdays ‒ QlikView