topic Re: Last Working Day Of A Week in QlikView

Last Working Day Of A Week

anriretief — Wed, 24 Jun 2020 14:17:42 GMT

Is there a way to get the last working date in a specific week (where holidays should be excluded from the working days)?

So for example

Suppose Friday 2020/06/26 is the last day of the week but it is a public holiday. Then I want to obtain the date of the Thursday (which in this case would be 2020/06/25)

I know how to get the last working day of a month, but I am unsure how one would get it for a specific week.

Any help would be greatly appreciated

Re: Last Working Day Of A Week

Anonymous — Wed, 24 Jun 2020 14:32:44 GMT

I don't know your startdate, but maybe
firstworkkdate would do what you want
first parameter is your date (should be required weekend)
second parameter is number of workdays needed, which must be 1! you need 1 day to complete work
third parameter is list of your public holidays ('19.06.2020')
solution might be: firstworkdate('20.06.2020',1,'19.06.2020') results in 18.06.2020

if you only have a date within the week you just expand with the weekend function
firstworkdate(weekend('15.06.2020',)1,'19.06.2020') results in 18.06.2020
both assuming that friday 18th june is a public holiday (which in reality is not)

explanation: firstworkdate defines when you should start work so it will be completed in specified number of workdays!

does it helps or gives you an idea?

Re: Last Working Day Of A Week

anriretief — Wed, 24 Jun 2020 20:27:07 GMT

Thank you for the reply, I used the following:

LastWorkDate(weekstart(today()),networkdays(weekstart(today()),weekend(today()),'2020-06-25','2020-06-26'),'2020-06-25','2020-06-26') ... which then returns 2020-06-24 (assuming that 2020-06-25 and 2020-06-26 are holidays, although they are not in reality)