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.
create a variable containing all your holidays...
Chr(39)&concat(dateHoliday,Chr(39)&','&Chr(39))&Chr(39) as concatenatedHolidays
let vVariable_containing_all_holidays = peek('concatenatedHolidays',0,'Concat');
drop table Concat;
then you should be able to use it:
networkdays(Date1,Date2,$(vVariable_containing_all_holidays )) as NetworkdaysValue
ah I can see its been answered here
Solved: Using a variable in NetWorkDays function? - Qlik Community - 1270693