Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Would you be able to share few lines of sample data with your expected output?
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