Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

week subtraction

Hi Team,

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.



3 Replies

Re: week subtraction

To subtract use


if the format is always the same.

Honored Contributor III

Re: week subtraction


may be




Not applicable

Re: week subtraction

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?