topic Re: Add working days to a date in App Development

Add working days to a date

Loki13 — Tue, 18 Feb 2025 09:17:03 GMT

Hello,

I have table where I have two columns. One column with the shipment date and the other with transport delays (in days) I would like to create a column where I will calculate the receipt time but only by adding working days since there's no transport during non working days.

Thank you

Re: Add working days to a date

Clement15 — Tue, 18 Feb 2025 10:58:53 GMT

Hello,

you can use a formula like this:
networkdays(Order_Date,Delivery_Date)

networkdays - script and chart function | QlikView Help

Re: Add working days to a date

Loki13 — Wed, 19 Mar 2025 14:53:45 GMT

Hello,

I would like to add working days to the date not count the number of working days between two dates.

Thank you 🙂

Re: Add working days to a date

Chanty4u — Wed, 19 Mar 2025 19:41:13 GMT

Try this

ReceiptDate = WorkDate([Shipment Date], [Transport Delays])

Re: Add working days to a date

Loki13 — Wed, 26 Mar 2025 10:23:07 GMT

It didn't work. 😞

Re: Add working days to a date

marcus_sommer — Wed, 26 Mar 2025 12:15:07 GMT

Take a look here: firstworkdate - script and chart function | Qlik Cloud Help

Re: Add working days to a date

lennart_mo — Wed, 26 Mar 2025 12:58:06 GMT

Hi @Loki13,

I would try achieving this through the backend.

The best idea that I've got right now would be to create a table containing all working days and then use FieldIndex() and FieldValue().

If you created a table called 'WorkingDays' with a field called 'Work_Date' the calculation might look something like so:

FieldValue('Work_Date', FieldIndex('Work_Date', ShipmentDate) + Delay) as ReceiptDate

It would only work if all the shipping dates are working days as well.

Hope this helps!

Re: Add working days to a date

marcus_sommer — Wed, 26 Mar 2025 13:40:04 GMT

There is already in nearly all scenarios such a table - the master calendar. Just adding there a 0/1 workingday-flag against querying weekends/holidays and then accumulating this value against the month/year/calendar-start/... and then using these information in n mappings, like:

m1: mapping load Date, RunningWorkingday from Calendar;

m2: mapping load RunningWorkingday, Date from Calendar;

t: load *, applymap('m2', Delay + applymap('m1', Date, null()), 'myDefault') as ReceiptDate
from X;