Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
pipuindia99
Contributor III

NetworkDays in script

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.

test.pngexample

 

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;

Labels (1)
1 Solution

Accepted Solutions
pipuindia99
Contributor III

Re: NetworkDays in script

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 🙂

2 Replies
MVP & Luminary
MVP & Luminary

Re: NetworkDays in script

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)'  ;

 


talk is cheap, supply exceeds demand
pipuindia99
Contributor III

Re: NetworkDays in script

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 🙂