topic Working Days + Excel in QlikView

Working Days + Excel

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Working Days + Excel

antoniotiman — Tue, 01 Aug 2017 15:01:37 GMT

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