Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
bullish35
Contributor II

Derive StartDate by subtracting number of week days from FinishDate

Hello Community!

I am working with a 'EndDate' value and have to calculate the 'StartDate' value based on a duration of 17. The easy answer is . . .

     AddDays(EndDate, -10) as StartDate

However, when calculating the StartDate, I need to subtract 17 work days and exclude weekends from my calculation.

     In simple mathematical terms, I want to solve for EndDate - 17 working days = StartDate

Without both a start and finish date, I can not use the NetworkDays function. (I've reviewed this post: Excluding weekends from one date minus another..; different issue.)

Any suggestions or examples? Either would be greatly appreciated.

Regards,

Ellen