Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
shane_spencer
Valued Contributor

Master Calendar with Working days & Holidays Flag

I'm trying to use Firstworkdate to evaluate the previous working day, using a different set of holidays on a line by line basis depending on country.

firstworkdate.PNG

My Test case is FR (France) for MAR-2019. For every record I want to take into account holidays in SG and US, hence the two variables, vHoliday_SG and vHoliday_US.

VALUE_DATE_PAYMENT_0 gives a date of 22-Apr which is correct but does not take into account local holidays
VALUE_DATE_PAYMENT_1 gives a date of 18-Apr which is correct and uses 43577 (22-Apr) hardcoded
VALUE_DATE_PAYMENT_2 gives a date of 18-Apr which is correct and used vHolidays_FR
VALUE_DATE_PAYMENT_3 gives a date of 22-Apr which is incorrect because it does not take into account local holidays i.e. FR
VALUE_DATE_PAYMENT_4 gives a date of 22-Apr which is incorrect because it does not take into account local holidays i.e. FR

How can I get Firstworkdate to take into account local holidays on a line by line basis, by either using the LOCAL_HOLIDAYS field or the vHolidays_XX variables where XX is based on COUNTRY field?

Please find attached source data qvd and qvw in zip file for testing.

Labels (1)