topic Re: Rolling 52 weeks in QlikView

Rolling 52 weeks

Shiva123 — Mon, 11 Sep 2017 17:52:36 GMT

hello,

every one i have a typical scenario where in i have to create a variable for rolling 52 weeks (exactly a year ago ) using another variable (which changes every week) so that i could limit my data for Rolling 52 weeks. First of all is this the right way of liming data by using variable? or is there any procedure, if so could you please let me know .

Thanks in advance

Re: Rolling 52 weeks

Anil_Babu_Samineni — Tue, 12 Sep 2017 02:06:37 GMT

If you need exact 1 year back comparison you can use this?

Sum({<Year = {">=$(=AddYears(Max(Year), -1)) <=$(=Max(Year))"}>} Sales)

Re: Rolling 52 weeks

rohitraut — Tue, 12 Sep 2017 05:58:54 GMT

Hello Shiva,

Try this,

Rolling 52 Weeks:

=count({<Week={"<=$(=Week(max(Date))) >= $(=Week(max(Date))-52)"}>}Date)

Hope this helps!

Re: Rolling 52 weeks

mostwanted123 — Tue, 12 Sep 2017 07:41:12 GMT

Hi Shiva,

For Rolling 52 weeks,

Sum({<Date={">=$(=Week(max(Date))-52)<=$(=Week(max(Date)))"}>}Sales)

Regards,

Pratik Bhor