topic Re: Calculating lead time between order date and delivery date in QlikView

Calculating lead time between order date and delivery date

petermoyaert — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Calculating lead time between order date and delivery date

ujjwalraja — Wed, 04 Jul 2018 13:13:37 GMT

Hi Peter,

You can use Networkdays() function.

Go through this link

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/networkdays.htm

Re: Calculating lead time between order date and delivery date

Neymar_Jr — Wed, 04 Jul 2018 13:20:00 GMT

Hi,

Did you give networkdays() a try?

Thanks,

Re: Calculating lead time between order date and delivery date

Anil_Babu_Samineni — Wed, 04 Jul 2018 13:40:21 GMT

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

Re: Calculating lead time between order date and delivery date

ljackson — Wed, 04 Jul 2018 14:57:08 GMT

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

Re: Calculating lead time between order date and delivery date

sohb2015 — Sat, 07 Jul 2018 05:08:08 GMT

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