Discussion Board for collaboration on QlikView Scripting.
I have data as below:
in separate table i have a list of holidays.
How can I calculate work days between this two dates and include the holiday list?
Go to Solution.
And Look at this
Find Net Working Days
define a variable for your Holidays and selet the data from your Holiday list
LET vHolidays= concat(yourholidayfield,',')
and use function
networkdays(DATE A, DATE B, '$(vHolidays)')
NetworkingDays(DATE A,DATE B,HOLIDAYS)
Another way to calculate working-days could be to create a flag within your master-calendar and simply to summarize this flag-field, like: sum(WorkingdaysFlag), see here an example:
Master Calendar with movable holidays
A clear example from manual,
If you have multiple dates, then assign the dates in variable and follow the syntax suggested by Rudolf.