Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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.

exampleexample

 

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
Highlighted
Creator III
Creator 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 🙂

View solution in original post

2 Replies
Highlighted
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
Highlighted
Creator III
Creator 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 🙂

View solution in original post