Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load holiday list into variable in script

Hi,

in order to use the below function I would like to load a list of holidays into a variable.

FirstWorkDate(Today(), 1, $(vMyHolidays))

Im stuck.

Any ideas?

Attaching example data and QV-doc.

//O

12 Replies
Not applicable
Author

Maybe this could help.

Calculating Holidays in script

NareshGuntur
Partner - Specialist
Partner - Specialist

01-Jan still is not labeled as holiday.

Please check this dashboard. Working fine if 01-Jan is declared in holiday list.

Cheers,

Naresh

Not applicable
Author

Ok, but pls see below. Then for date 2-jan, the answer should be 30-dec 2014 right?

Now it says 31-dec-2014 even though it is also declared as a holiday in the list.

Do you know why?

Capture.JPG