topic Re: Network days in QlikView

Network days

cooper_yonk — Wed, 06 Jul 2022 15:18:17 GMT

Good morning

Could anyone help me with this please.

I have a list of bank holidays in excel and I want to use them in my script in conjunction with network days.

,if(IsNull(CompletedDate),NetWorkDays(CreatedDate,today())-1,NetWorkDays(CreatedDate,CompletedDate)-1) as WorkingDays_calc;

Ive seen that I can add a variable to this formula to exclude public holidays. My question is how do I use the bank holiday dates in my spreadsheet with this formula

Any help would be appreciated.

Re: Network days

mikaelsc — Wed, 06 Jul 2022 15:48:26 GMT

create a variable containing all your holidays...

Holidays:

load

dateHoliday

from SourceExcelHolidays;

Concat:

load

Chr(39)&concat(dateHoliday,Chr(39)&','&Chr(39))&Chr(39) as concatenatedHolidays

resident Holidays;

let vVariable_containing_all_holidays = peek('concatenatedHolidays',0,'Concat');

drop table Concat;

then you should be able to use it:

load

networkdays(Date1,Date2,$(vVariable_containing_all_holidays )) as NetworkdaysValue

from SourceDataThingStuff;

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/networkdays.htm

Re: Network days

cooper_yonk — Wed, 06 Jul 2022 15:50:21 GMT

ah I can see its been answered here

Solved: Using a variable in NetWorkDays function? - Qlik Community - 1270693