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.

Thanks

Khushboo

3 Replies

Re: week subtraction

To subtract use

Right(yourfield,2)

if the format is always the same.

antoniotiman
Honored Contributor III

Re: week subtraction

Hi,

may be

WeekName(MakeWeekDate(Left(YearWeek,4),Mid(YearWeek,5)),-13)

Regards,

Antonio

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?