Consider only working days during date offset

[#1]

Hi,

I have to create  a Pivot table report with 2 date dimensions - Start date and Completion date.

Start Date is pulled from master calender

Completion date is Start Date offset by a value that is entered by a user in inputbox.

Example, if inputbox=14, then completion date= Start date+ 14 WORKING DAYS(Mon-fri and NOT Mon-Sun)

Please guide me on how to proceed.

[sunny_talwar]

Would you be able to share few lines of sample data with your expected output?

[jonathandienst]

Have a look in the help documentation, the reference manual and here for the working date functions:

     NetWorkDay(<first date>, <second date>)

     FirstWorkDate(<end date>, <no of workdays>)

     LastWorkDate(<start date>, <no of workdays>)

In your case, you could use LastWorkDate with the start date and offset.

See also: YA(H)Q Blog: Qlikview Working Day Functions 1