topic Re: Rolling 12 months in QlikView

Rolling 12 months

Fri, 13 Apr 2012 03:37:18 GMT

i have to show 12 rolling months actual cost and my dimension are 3 or 4 like job month den what to do and all these i want to present in bar chart nd in pivot table den plz help me...

Re: Rolling 12 months

jjfabian — Fri, 13 Apr 2012 13:41:45 GMT

Hi Sanya,

the SAP Sales Distribution Demo has a rolling Average has a rolling average in it (Billing Trends Tab, Rolling 3 6 12 Chart). The used formula is:

rangeavg(above(Sum([Billing Sales Amount_NETWR]),0,12))

You can look it up here if you want to see it for yourself here:

http://eu.demo.qlik.com/detail.aspx?appName=SAP-Sales%20Distribution.QVW

Hope this helps you out,

regards Jakob

Re: Rolling 12 months

SunilChauhan — Fri, 13 Apr 2012 14:08:11 GMT

see the attached file

hope this helps

Re: Rolling 12 months

Thu, 04 Jul 2013 13:44:37 GMT

Hi, i know you post is old, but can you explain what fields are the ones you use.

Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1), 'MMM-YY'))"} >} Sales)

YearMonth

Date

Sales

Re: Rolling 12 months

Sat, 27 Dec 2014 12:37:33 GMT

But what is the mean of this ?????

plz tell