Discussion board where members can get started with Qlik Sense.
I have data at yearweek level.
say 201513 which is 13th week for 2015 year.
I want to substract weeks from this . I know it is incorrect to use max(YearWeek)-13.
Also i know it would have been better to use dual while week creation. but this weeks are already present in the DB ( they have 445 calendar concept).
What is the best way to do it at week level.
To subtract use
if the format is always the same.
in the above scenario, what will happen if the week is first ,
say we have data from 201401 to 201501.
if i minus from 201501 , it will show me incorrect?
How to deal with this?