Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
maudifer
New Contributor III

Rolling Weeks over 2 different years

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 ?

 

 

 

1 Reply
vvira1316
Valued Contributor II

Re: Rolling Weeks over 2 different years