topic Re: Using NetWorkDays to subtract one date from another in QlikView

Using NetWorkDays to subtract one date from another

Anonymous — Thu, 27 Jul 2017 07:43:45 GMT

Hello everyone,

I use =NetWorkDays to see the difference from one date to another. It works great for the main part.

I want to compare the Order Date and the Receive Date between tables in order to see the lead time. However, in some cases the Order Date is higher than the Receive Date. Since Networkdays checks the difference, it gives me false data in some cases.

Therefore I want to subtract the Receive Date with the Order Date to make sure that I get the right values. Then I can filter out the negative values.

Now I use =NetWorkDays([Last receive date],[Order date]). The format of the dates are 13-07-2017 (receive) and 06-07-2017 (order),

Is there some way to use it more like =NetWorkDays([Last receive date] minus [Order date]).?

Thank you

Re: Using NetWorkDays to subtract one date from another

sunny_talwar — Thu, 27 Jul 2017 15:42:21 GMT

May be like this

If([Last receive date] > [Order date], -NetWorkDays([Order date], [Last receive date]), NetWorkDays([Last receive date], [Order date]))

Re: Using NetWorkDays to subtract one date from another

Anonymous — Fri, 28 Jul 2017 07:24:08 GMT

Hey, that's a really smart solution! I did not think of doing it like that.

Thanks a lot!