problem using variable for holidays in script

Wed, 07 Apr 2010 01:54:40 GMT

Hi everyone,

In script, I want to store my holidays in a variable, but I have some problem to use it in networkdays function. I try to calculate the number of holidays between 2 dates. Here is my script:


SET Holidays='5/10/2009, 25/12/2009, 26/12/2009, 1/01/2010, 26/01/2010, 2/04/2010, 5/04/2010, 26/04/2010, 14/06/2010, 4/10/2010, 27/12/2010, 26/01/2011';
SET Holidays_script='Chr(39) 5/10/2009 Chr(39),Chr(39) 25/12/2009 Chr(39),Chr(39) 26/12/2009 Chr(39),Chr(39) 1/01/2010 Chr(39),Chr(39) 26/01/2010 Chr(39),Chr(39) 2/04/2010 Chr(39),Chr(39) 5/04/2010 Chr(39),Chr(39) 26/04/2010 Chr(39),Chr(39) 14/06/2010 Chr(39),Chr(39) 4/10/2010 Chr(39),Chr(39) 27/12/2010 Chr(39),Chr(39) 26/01/2011 Chr(39)';

if(LOG_CNT=1,
 'begin',
 if(TRAY_NO=peek(TRAY_NO),
 (networkdays(peek(AMD_DATE),AMD_DATE)-networkdays(peek(AMD_DATE),AMD_DATE,$(Holidays))),
 'pb'
 )
 ) as holidays_between,

When I try $(Holidays), I have only begin, pb and 0 values, so it's not working properly because between some dates I have holidays between.. When I try the formula with $(Holidays_script), I have an error message: ")" expected, but I don't know where it comes from. Does anyone have an idea for the good syntax?

Thank you for your help.

topic problem using variable for holidays in script in QlikView

problem using variable for holidays in script