topic Re: Rolling Vs Previous in QlikView

Rolling Vs Previous

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have posted a query w.r.t this topic already, but still unable to differentiate between these 2:

Ex Scenario:

I have data for 2015,2016,2017 (Jan till Dec for all years). i need to compare in a bar chart the Rolling12 months sales to Previous12months sales.

For rolling12 months i used the below in expression:

=Sum({<Date={"$(='>=' & Date(MonthStart(Max(Date), -13)) & '<' & Date(MonthStart(Max(Date))))"}>} Sales)

PeriodID = {">=$(=Max(PeriodID)-11)<=$(=Max(PeriodID))"}

This is resulting in Rolling 12 months. Like 2017 Jan Till Dec sales.

If i want to calculate the previous12 months will it be like : present month April 2018 back 12 months which is May 2017 Till April 2018, is my assumption correct or not?

Can any one please suggest a code to calculate previous12months, i worked out with almost all links provided in community, i can see Rolling12months but not Previous12months.

Can i get a response on my scenario please?

Re: Rolling Vs Previous

vishweshwarisun — Thu, 05 Apr 2018 10:57:39 GMT

try this:

Sum({< Month=, Date={">=$(=MonthStart(today(), -11))<=$(=(today()))"}>}Sales)

Re: Rolling Vs Previous

sunny_talwar — Thu, 05 Apr 2018 11:33:11 GMT

I would suggest you to look into The As-Of Table and I think mrkachhiaimp‌ have already showed a demonstration of the same here Previous12 and Rolling12

Re: Rolling Vs Previous

Anonymous — Thu, 05 Apr 2018 14:01:09 GMT

Thanks Sunny, nice reference.

Re: Rolling Vs Previous

Anonymous — Thu, 05 Apr 2018 15:37:52 GMT

Hi Vishveswari,

I tried that, but in my case i should not be using Today(), as i have no data for 2018, i worked out by creating Flags in the backend script and seems to be working alright, thank you very much for the reply.

Regards