ROLLING 16 Months Growth

[#1]

Hi

I want to represent Last 16 Month Rolling Growth%.

I have Sales of  Products for 3 Years.

Growth will be calculated as

for Eg. Oct 2013 Growth= (Oct 2013 Sales - Oct 2012 Sales)/Oct 2012 Sales.

I have to use Month Year as Dimension.

Thanks and Regards

[sunilkumarqv]

You can follow below Link . Henric  Post

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

  Sum( {$<Date={">=$(=MonthStart(AddMonths(Max(Date),-16)))<$(=MonthEnd(Max(Date)))"}>} Sales)

[PrashantSangle]

hi,

Rolling 12 months=(sum({<CalendarDate={"$(=Date(Max(CalendarDate)))"}>} Sales)

-sum({<CalendarDate={"$(=Date(AddMonths(max(CalendarDate),-12)))"}>}Sales))

/sum({<CalendarDate={"$(=Date(AddMonths(max(CalendarDate),-12)))"}>}Sales)

try this set analysis.

[#4]

but if i will use Month Year(eg. oct 2013) as Dimension i will not get the desired Result.

[#5]

but if i will use Month Year(eg. oct 2013) as Dimension i will not get the desired Result and i want to calculate sales growth which is a calculated expression.

[sunilkumarqv]

Hi Himank,

Please follow below link Calculating rolling n-period totals, averages or other aggregations  its Realy Good

You may get solution

[#7]

Use makedate function in the set analysis. that is make date from Oct 2013

[#8]

Dear Sunil

I have gone through it and i understand that i can calculate rolling months Sales but i want to know how can i calculate Rolling Months Growth% with Dimension as Month Year

[PrashantSangle]

Hi,

if possible can you upload sample data with desired result

[#10]

Hi

I have attached an Excel where  i have specified Input and what output i want  in a straight table or bar chart.

Thanks and Regards