Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling 12 months

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...

4 Replies
jjfabian
Partner - Creator III
Partner - Creator III

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

SunilChauhan
Champion
Champion

see the attached file

hope this helps

Sunil Chauhan
Not applicable
Author

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

Not applicable
Author

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

plz tell