WeekEnd(Date+1, 1, 5) as Deadline,
WeekStart(Date, -2, 4) as StartDate;
LOAD * Inline
Community_205971.qvw 149.8 K
Like Oleg mentioned below WeekStart and WeekEnd can be shifted + offset by using its 2nd and 3rd parameter, respectively. I just played around with those parameters to get you what you were looking for. No magic at all
I think I have got the order incorrect above
2nd parameter is WeekOffset
3rd paramter is shift the weekdays
I suggest to look at the functions WeekStart and WeekEnd - notice the option parameters shift and weekoffset that allow you to move a certain number of weeks up or down, and move the first day of the week.
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!