topic Holidays in NetworkDays for Different Countries in QlikView

Holidays in NetworkDays for Different Countries

Anonymous — Wed, 27 Sep 2017 11:20:00 GMT

Hey guys,

I am trying to calculate lead times using the NetworkDays function in QlikSense but I need to distinguish the holidays for different countries. As you know, in Europe every country has its own holiday calendar and I would like to take that into account (to eliminate the holiday from the total lead time).

I would like to use an Excel file where I can keep track of all the holidays for each country (like the format below). What is the best way to do this?

Country	Holiday
DE	01-Jan-17
DE	05-May-17
ES	03-Mar-17
ES	14-Aug-17
AT	24-Dec-17
AT	25-Dec-17

Re: Holidays in NetworkDays for Different Countries

sunny_talwar — Wed, 27 Sep 2017 11:25:24 GMT

May be check this out

Exclude holidays using Networkdays() in script

Re: Holidays in NetworkDays for Different Countries

Wed, 27 Sep 2017 11:47:01 GMT

As i understand, you would like to calculate real number of day in month, excluding holidays (if are not a saturday or sunday). I use below solution in charts as expresion calculation with set analysis.

For first you shoud make a list of holidays with option and load it into data model:

- Country

- flag Y/N if the day is a saturday/sunday or not

It may be table without realations to others.

Try to use folowing expresion:

NetWorkDays(MonthStart(ReloadTime()),date(ReloadTime()),'$(=Concat( {1<SaturdaySundayFlag={N},Country={value}>} distinct [HolidayDate],chr(39)&','&chr(39)))'))