topic Re: Rolling N months in QlikView

Rolling N months

nakuldev — Sat, 16 Nov 2024 19:39:13 GMT

Hi All,

In MonthYear filter, if I select Nov-2019, chart should show data for previous month i.e; Oct-2019, like wise if I select 3 months (Nov-2019,Oct-2019 and Sep-2019) then the same chart should show data for previous three months i.e; (Jun-2019,July-2019 and Aug-2019).

Appreciate the support in advance.

Thanks

Nakul

Re: Rolling N months

sunny_talwar — Mon, 18 Nov 2019 12:27:48 GMT

If you select Jan-19 to Oct-19 which is 10 months... you would want to see Mar-18 till Dec-18?

Re: Rolling N months

nakuldev — Tue, 19 Nov 2019 04:14:06 GMT

Hi Sunny!

Thank you for quick reply. Yes! If we select Jan-19 to Oct-19 which is 10 months... you would want to see Mar-18 till Dec-18.

If not at least for the same year (max upto 4 months) will be fine.

Thanks

Nakul

Re: Rolling N months

sunny_talwar — Tue, 19 Nov 2019 11:41:51 GMT

Here is what you can try

=Sum({<MonthYear = {">=$(=Date(MonthStart(Min(MonthYear), -GetSelectedCount(MonthYear)), 'MMM-YYYY'))<=$(=Date(MonthStart(Max(MonthYear), -GetSelectedCount(MonthYear)), 'MMM-YYYY'))"}>}Sales)

Basically, as long as you select the all the months between start and end, you can go back the number of MonthYear selected from the Min and Max MonthYears selected.

Re: Rolling N months

Brett_Bleess — Wed, 20 Nov 2019 17:56:47 GMT

Nakul, it looks like Sunny's last post likely got you what you needed, if that is the case, please be sure you circle back to the thread and use the Accept as Solution button on his last post if that did the trick. This gives him credit for the help and lets other Community Members know his solution actually worked for your use case. If you still need further help, leave an update for us.

Regards,
Brett

Re: Rolling N months

nakuldev — Tue, 10 Dec 2019 07:30:18 GMT

Thank you Sunny! Sorry for the delay.

Regards

Nakul