Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

sum over 12 month for each month

Hi

I have a chart where for each month I need the cumulative sum of value over previous 12 months prior to that month

for example:

Jan 2016 = SUM({< MONTHS=Feb 2015 - Jan 2016  >} VALUE)

Feb 2016 = SUM({< MONTHS=Mar 2015 - Feb 2016  >} VALUE)

etc...

Thank you in advance for your help

5 Replies
Highlighted

You want to show values while selection?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

YES

Highlighted

Here is one approach:

The As-Of Table

Other one is to use RangeSum(Above()) function on the front end

Highlighted
Contributor III
Contributor III

Script:

Num([DateField])as NumDate

Graphic:

Sum({1<

NumDate={$(='">= ' & $(=Num(MonthStart(AddMonths(min(Num([DateField])),-11)))) & ' <= ' & $(=floor(num(max([DateField])))) &'"')}

>} [AmountField])

Highlighted
Creator III
Creator III

Hi,

Did you got the solution for this.