Loading country speciffic holidays into NetWorkDays

[Posb1]

Hello,

To calculate delivery times I need to use NetWorkDays with a list of holidays that differs based on the country. I have the following script:

//loading all shipments

tempLeadTime:

LOAD

     shipmentNumber,

     Customer,

     dateShipmentCreated

FROM [...Shipment.qvd] (qvd);

//adding loading date

LEFT JOIN (tempLeadTime)

LOAD

     shipmentNumber,

     loadingDate

FROM [...loading.qvd] (qvd);

//adding delivery date and country

LEFT JOIN (tempLeadTime)

LOAD

     shipmentNumber,

     deliveryDate

     countryCode

FROM [...delivery.qvd] (qvd);

I have a table available in the script containing countries and  a list of holidays formatted like the variable I normally use to insert a list of holidays into NetWorkDays.

An example selection:

AT	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44567','44666','44682','44696','44788','44860','44866','44867'
BE	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44682','44763','44788','44866','44876'
BG	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44623','44675','44676','44682','44810','44826','44866'
CH	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44567','44666','44774','44788','44866','44867'
CZ	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44666','44682','44689','44747','44748','44862','44882'
DE	'44562','44668','44669','44678','44707','44717','44718','44920','44921','44567','44666','44682','44728','44788','44837','44865','44866'

How can I insert the right list of holidays into the NetWorkDays to get a realistic leadtimes based on country specific holidays?

[anat]

https://community.qlik.com/t5/QlikView-App-Dev/Exclude-holidays-using-Networkdays-in-script/td-p/566...

[anat]

https://community.qlik.com/t5/QlikView-App-Dev/Match-countries-to-get-holidays-for-NetWorkDays-formu...