topic NetworkDays in script in QlikView

NetworkDays in script

pipuindia99 — Sat, 16 Nov 2024 20:40:32 GMT

Hi All,

Have an issue with networkdays function when i use it script

There is a holiday on 6/6/2019 for a country. and in the below script there are multiple countries involved and for each country there are common and also different holidays.

so the question is how to assign the values of dates to a variable so that the variable can be used in networkdays function as a 3rd parameter if we select a country in list box.

example

LOAD * Inline
[Indate, Outdate
6/5/2019, 6/7/2019];

Holiday:
LOAD Slno,
Country,
Num([Holiday_Date]) as Public_Holiday_Date_Num,
date(Holiday_Date) as Public_Holiday_Date,
FROM
[..\..\Holiday list 2019_US_EU.xlsx]
(ooxml, embedded labels, table is Sheet1);

Holiday_List:
load
concat(chr(39) & Public_Holiday_Date_Num & chr(39),',') as ListOfHolidays_Num,
Country
Resident Holiday Group By Country;

DROP Table Holiday;

LET vListOfHolidays = ; ????

EXIT SCRIPT;

Re: NetworkDays in script

Gysbert_Wassenaar — Thu, 13 Jun 2019 09:48:13 GMT

Holiday_List:
load
concat( Public_Holiday_Date_Num,',') as ListOfHolidays_Num,
Country
Resident Holiday Group By Country;

DROP Table Holiday;

LET vListOfHolidays = '=Only(ListOfHolidays_Num)' ;

Re: NetworkDays in script

pipuindia99 — Thu, 13 Jun 2019 09:53:08 GMT

thanks Gysbert, it worked i tried mulitple ways like using peek, fieldvalue and even only function as well, nothing worked. and now i remember to include "=" in front of only 🙂