Holidays in NetworkDays for Different Countries

[Anonymous]

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

[sunny_talwar]

May be check this out

Exclude holidays using Networkdays() in script

[#3]

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