topic Consider only working days during date offset in QlikView

Consider only working days during date offset

Thu, 10 Dec 2015 06:56:35 GMT

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 — Thu, 10 Dec 2015 12:27:23 GMT

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

jonathandienst — Thu, 10 Dec 2015 12:37:09 GMT

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.