Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Business Days help

Hi,

I have the Actual Date field like below in the attached QVD.

Actual Date 2 .png

Could you please help me to add 35 business days.

I have null values also in Actual Date for those need to skip business days adding.

Requirement:

Now from this [Actual Date] I need to derive a New field called [Estimate Date] like below i.e.,

Value of [Actual Date] field + 35 business days

A “business day” is defined as any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year.

Please help me on this.

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Contributor II

Re: Business Days help

Hi Mahitham,

You can use lastworkdate function:
lastworkdate([Actual Date], 35) AS NextDate

Thanks,
Vitalii

View solution in original post

1 Reply
Highlighted
Contributor II

Re: Business Days help

Hi Mahitham,

You can use lastworkdate function:
lastworkdate([Actual Date], 35) AS NextDate

Thanks,
Vitalii

View solution in original post