Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mihai_iov
Creator II
Creator II

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
bhaskar_sm
Partner
Partner

3 Replies
bhaskar_sm
Partner
Partner

mihai_iov
Creator II
Creator II
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