Solved: Re: Rolling 12 months sum - Page 4 - Qlik Community

montubhardwaj · ‎2011-11-03

Hi All,

I have explained the isssue in the attached QV file. Please refer to this. This is about calculating rolling 12 months sum.

Thanks for your time.

Report Inappropriate Content · ‎2012-11-28

Fantastic!

Thank you for your quick respone.

It works great and I understand how it works.

Thank you.

Anonymous · ‎2013-01-10

Sajeevan,

Would it be able to show a shorter time frame than whole years. If you select in the chart from Oct 2011 to Jun 2012 it shows bars from Jan 2011 through to Jun 2012. In other words it seems to show from the start of min(year).

Many thanks,

Jonathan

Ignore this as I fund a solution, namely to add a Dimension limit of the largest count(disinct Month).

Jonathan

Anonymous · ‎2013-01-11

I have found that dimension limits is not very reliable under the ajax client, so am still interested in other solutions for how to restrict the number of months without the first month being set to January of the minimum year.

Jonathan

Report Inappropriate Content · ‎2013-01-13

Hi Jonathan,

Can you either attach an excel file or a QV file with a bit more clear explanation of your requirement? I will try my best to resolve.

Kind Regards,

Sajeevan

Anonymous · ‎2013-01-14

Hi Sajeevan,

The best way of my explaining is through screenshots of your application.

Please see in the attached document how, when a date selection is made the charts reduce the number of months shown, but instead of starting at the first date selected they go back to the start of the minimum year.

Many thanks,

Jonathan

Report Inappropriate Content · ‎2013-01-14

Hi Jonathan,

Now I got what you want to achive. You just need to add RollingPeriod={">=$(=Min(RollingPeriod)) <=$(=Max(RollingPeriod))"} in the expression. Find attached the same file after adding that expression to another chart object.

Hope this resolves your query.

Regards,

Sajeevan

Anonymous · ‎2013-01-14

Ignore previous post about not seeing change. I didn't look far enough down the sheet.

Apologies !!!

Jonathan

Report Inappropriate Content · ‎2013-07-26

That's really awesome Sanjeevan. Thanks for the reply !

You are genious !!!!

Report Inappropriate Content · ‎2015-03-24

Hi Sajeevan, can you please help me in this post?

http://community.qlik.com/thread/157330

I think the answer is almost like this one, tks

Report Inappropriate Content · ‎2015-04-23

Accumulate for past 12 months

please reply on this