Working Days + Excel

[qlikviewaf]

Hi Everyone,

i'm using this formula NetWorkDays(Date,Date) as WorkingDay to calculate working days; based on this all days from Monday to Friday are considered as working.

I would like to add an excel file, where to list only the holidays and have then the flag WorkingDay to 0 (which means non-working-day).

Anyone can help me and suggest me how to achieve this?

Thank you

[antoniotiman]

Hi Antonio,

File Excel like this below

Script :

LOAD Concat(DISTINCT Chr(39)&Holiday&Chr(39),',') as HDS;
LOAD Date(Holiday) as Holiday
FROM
[Holiday.xls]
(biff, embedded labels, table is Foglio1$);
LET vHolidays=Peek('HDS');

Expression :

=NetWorkDays('01/07/2017','31/07/2017',$(vHolidays))

Regards,

Antonio