topic Networkdays with holidays in QlikView

Networkdays with holidays

arsenal1983 — Mon, 21 Dec 2015 08:54:46 GMT

Hello,

I have data as below:

REK_id	DATE A	DATE B
10101111	2015-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?

Re: Networkdays with holidays

Anonymous — Mon, 21 Dec 2015 09:39:46 GMT

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

Re: Networkdays with holidays

sasikanth — Mon, 21 Dec 2015 09:42:06 GMT

HI,

try like

NetworkingDays(DATE A,DATE B,HOLIDAYS)

Re: Networkdays with holidays

marcus_sommer — Mon, 21 Dec 2015 09:46:44 GMT

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

tamilarasu — Mon, 21 Dec 2015 09:47:56 GMT

A clear example from manual,

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

Re: Networkdays with holidays

settu_periasamy — Mon, 21 Dec 2015 09:51:50 GMT

And Look at this

Find Net Working Days