topic Re: Bank holidays and week end in QlikView

Bank holidays and week end

guillaume_gorli — Wed, 19 Jul 2017 11:51:43 GMT

Hi All,

What would be the formula to get the difference between two date taking into account week end ?

For instance :

Date1 = Friday July the 21st

Date2 = Monday July the 24th

The difference between Date1 & Date2 should be 1

Last question, is there a way to take into account bank holidays as well ?

For instance July the 14th is bank holiday in France :

Date1 = Thursday July the 13th

Date2 = Monday July the 17th

The difference between Date1 & Date2 should be 1

Thanks in advance

Guillaume

m_woolf — Wed, 19 Jul 2017 11:55:51 GMT

look in Help for networkdays

sunny_talwar — Wed, 19 Jul 2017 11:55:53 GMT

Check this may be

zhadrakas — Wed, 19 Jul 2017 11:58:07 GMT

Usually you are using the networkdays function for that case.

That calculates the Difference between StartDate and EndDate excluding specific Holidays.

NetWorkDays(vStartDate ,vEndDate, '$(vListOfHolidays)')

For More Information about that see this threads:

guillaume_gorli — Wed, 19 Jul 2017 11:59:32 GMT

Thanks all for that, i will check as advised