Discussion Board for collaboration related to QlikView App Development.
is it possible to exclude list of holidays from NetWordDays function in Script?
Note: list contains company holidays of 2 years. so cant process this in Chart expression..
Thanks & Reagrds
Below code worked fine!
LOAD Day as Holiday
/************** varHoliday **************/
LOAD Chr(39) & Concat(Holiday,Chr(39)&','&Chr(39))&Chr(39) as fieldHoliday
LET varHoliday = Peek('fieldHoliday',0,'tmpTbl');
and then using below function inside table load:
NetWorkDays([Start Date],[End Date],$(varHoliday)) as WorkingDays
View solution in original post
Yes, you can use newtworkdays() in the script.
Yes, you can use any number of holidays in chart expression as well.
And, see this: Calculating Holidays in script
Thanks for sharing the informative post.
I already have an external file with list of holidays which is updated every year.
could you please suggest how do i modify the script to accommodate this?
No, I can't, because I don't know your application... or at least your script.