Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamically add holidays in QlikView

Hello.
I have a variable that I set in the loading script in which I'm holding the Holiday dates for the current year, in order to use those dates along with the NetWorkDays function to calculate the amount of working days. Right now, the values are hard-coded. How can I load the holiday dates from an external file, so that I don't have to change the loading script every time?

1 Solution

Accepted Solutions
3 Replies
bhaskar_sm
Partner - Creator III
Partner - Creator III

Anonymous
Not applicable
Author

Thanks

jyothish8807
Master II
Master II

Hi Mihal,

Create a variable like this, store your holidays in a seprate excel file and call the field in the below variable (Date filed in my case)

=Concat(chr(39)&Date&chr(39),',')

Use your expression like this:

=NetWorkDays('4/19/2018','4/30/2018',$(vHolidays))

refer attached. Hope it helps.

Br,

KC

Best Regards,
KC