Rolling Weeks over 2 different years

[maudifer]

Hi All,

I need to show the last 6 rolling week, but they are over 2 different year:

2018:49,50,51,52

2019: 1,2

For my rolling 12 months overlapping 2 years, iIuse this variable:

vCurrMonthID

=(($(vCurrYear)-1)*12)+$(vCurrMonth)

$vCurrYear=2019  vCurrMonth=1

And it works. But I can't seem to figure out how to make it work for weeks

For weeks, i would like to where vCurrWeekID would work like the month variable, but i don't how to write it.

I tried: 

vCurrWeekID

=(($(vCurrYear)-1)*52)+$(vCurrWeek) 

But it does not work.

Please, can you help me figure this out ?

[vvira1316]

You may want to try AsOf table
https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...

Check following link
https://community.qlik.com/t5/QlikView-Documents/Set-Analysis-for-Rolling-Periods/ta-p/1496283