topic Question about networkdays in QlikView https://community.qlik.com/t5/QlikView/Question-about-networkdays/m-p/236417#M87613 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I have a question about networkdays and holidays.</P><P></P><P>I have a table with country code and dates of festivity.</P><P></P><P>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.</P><P></P><P></P><P>Example table</P><P>Sender;CountryS;Receiver;CountryR;StartDate;Enddate</P><P>1;ES;2;PT;02/01/2010;15/02/2010</P><P>1;ES;2;IT;02/01/2010;17/02/2010</P><P></P><P>Then I have another table with</P><P>FEST:</P><P>CountryR;Days</P><P>PT;04/01/2010</P><P>PT;07/01/2010</P><P>IT;05/01/2010</P><P></P><P>I want to do a networkdayes(StartDate,Endate;FEST DAYS THAT COUNTRY is COUNTRYR)</P><P></P><P>How can I do that function.</P><P></P><P></P><P>Best regards;</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Wed, 28 Jul 2010 16:38:09 GMT 2010-07-28T16:38:09Z Question about networkdays https://community.qlik.com/t5/QlikView/Question-about-networkdays/m-p/236417#M87613 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I have a question about networkdays and holidays.</P><P></P><P>I have a table with country code and dates of festivity.</P><P></P><P>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.</P><P></P><P></P><P>Example table</P><P>Sender;CountryS;Receiver;CountryR;StartDate;Enddate</P><P>1;ES;2;PT;02/01/2010;15/02/2010</P><P>1;ES;2;IT;02/01/2010;17/02/2010</P><P></P><P>Then I have another table with</P><P>FEST:</P><P>CountryR;Days</P><P>PT;04/01/2010</P><P>PT;07/01/2010</P><P>IT;05/01/2010</P><P></P><P>I want to do a networkdayes(StartDate,Endate;FEST DAYS THAT COUNTRY is COUNTRYR)</P><P></P><P>How can I do that function.</P><P></P><P></P><P>Best regards;</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Wed, 28 Jul 2010 16:38:09 GMT https://community.qlik.com/t5/QlikView/Question-about-networkdays/m-p/236417#M87613 2010-07-28T16:38:09Z