Discussion Board for collaboration related to QlikView App Development.
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
Thanks in advance
Go to Solution.
Check this may be
networkdays - script and chart function ‒ Qlik Sense
View solution in original post
look in Help for networkdays
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:
Exclude holidays using Networkdays() in script
Network days less Public Holidays | Qlik Community
Thanks all for that, i will check as advised