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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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