Dynamically add holidays in QlikView

[Anonymous]

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?

[bhaskar_sm · Accepted solution]

Hi,

please check this out:

https://www.quickintelligence.co.uk/variables-parameters-load-script/

[Anonymous]

Thanks

[jyothish8807]

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