Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

arsenal83
Contributor

Networkdays with holidays

Hello,

I have data as below:

  

REK_idDATE ADATE B
101011112015-12-30

2016-01-08

in separate table i have a list of holidays.

How can I calculate work days between this two dates and include the holiday list?

Tags (1)
1 Solution

Accepted Solutions

Re: Networkdays with holidays

And Look at this

Find Net Working Days

5 Replies
hrlinder
Honored Contributor

Re: Networkdays with holidays

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)')

sasikanth
Valued Contributor III

Re: Networkdays with holidays

HI,

try like

NetworkingDays(DATE A,DATE B,HOLIDAYS)

MVP & Luminary
MVP & Luminary

Re: Networkdays with 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

- Marcus

Re: Networkdays with holidays

A clear example from manual,

Capture.PNG

If you have multiple dates, then assign the dates in variable and follow the syntax suggested by Rudolf.

Re: Networkdays with holidays

And Look at this

Find Net Working Days