Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question about networkdays

Dear all,

I have a question about networkdays and holidays.

I have a table with country code and dates of festivity.

I want to do a networkdays function between one start date and end date, but using as holidays date of destiny country, but i have no idea how to do that.

Example table

Sender;CountryS;Receiver;CountryR;StartDate;Enddate

1;ES;2;PT;02/01/2010;15/02/2010

1;ES;2;IT;02/01/2010;17/02/2010

Then I have another table with

FEST:

CountryR;Days

PT;04/01/2010

PT;07/01/2010

IT;05/01/2010

I want to do a networkdayes(StartDate,Endate;FEST DAYS THAT COUNTRY is COUNTRYR)

How can I do that function.

Best regards;

0 Replies