Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
petermoyaert
Contributor III
Contributor III

Calculating lead time between order date and delivery date

Hi there,

I have a Qlikview overview that shows for each invoice the order date and the delivery date.

Substracting both dates gives me the lead time between order and delivery.

However, the result of this formula is influenced negatively by weekend days.

Does someone know if it possible to calculate only working days between two dates within Qlikview. In excel it is feasible but it would be great if I could get this information within the Qlikview table of course.

Thanks for your feedback or ideas.

Peter

5 Replies
ujjwalraja
Contributor III
Contributor III

Neymar_Jr
Creator II
Creator II

Hi,

Did you give networkdays() a try?

Thanks,

RT

Anil_Babu_Samineni

Try to share that excel file which working so then we may replicate that in View.

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
ljackson
Creator
Creator

In your master calendar, could you identify which days are work days, and which weekend? 

Load this as a new dimension and use in the set analysis

sohb2015
Contributor III
Contributor III

Hi,

Networkdays will resolve the issue. Passing Order date as Start date and Delivery date as end date will give you the working days.

Hope it helps.

Thanks