I am taking data from an Excel, where the date is shown like 201709 (YEAR,WEEK).
Now I am using a variable to put the date input inside and use the makeweedate() to create a proper date for QlikView (which creates the start date of the corresponding week, e.g. 2/27/2017) and with weekname() I am going "back" to the originally shown presentation, the calendarweek: 2017/09
With this 2017/09, I usually would like to go back to week 8 etc., I thought its possible by deducting -1. BUT than QV shows 42792, that's 2/2672017. So one day instead of one week deducted.
Anyway is there a easy way to jump to different weeks from this point? I don't want to deduct always -7,-14,-21 days :/.
Thanks for any support.