Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to do rolling 12 months sum

Good morning, I'm a qlik sense beginner. I would like to know how to do rolling last 12months sum, by selecting a month / year. Thank you.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: How to do rolling 12 months sum

I found a way to do it.

Sum({$< [udolar_fecha_emision.autoCalendar.YearMonth]={'>=$(=Monthstart(Addmonths(Max(udolar_fecha_emision),-11)))<=$(=Max(udolar_fecha_emision))'} >}udolar_subtotal_descuento)

What do you think about it?

View solution in original post

14 Replies
Highlighted

Re: How to do rolling 12 months sum

Highlighted
Not applicable

Re: How to do rolling 12 months sum

does it works the same for qlik sense?

Because it seems like qlikview.

Highlighted

Re: How to do rolling 12 months sum

Most of the things should work except for the option to accumulate using the accumulate check box on expression tab which is only available in QlikView

Highlighted
Not applicable

Re: How to do rolling 12 months sum

ok i am gonna try it and let you know. thanks

Highlighted
Not applicable

Re: How to do rolling 12 months sum

Where do I put the year in the expression?      rangesum(above(sum(Amount),0,3))

Example: if I select november- 2016


I want the sum rolling last 12 months (from december 2015 to november 2016)




Highlighted
Not applicable

Re: How to do rolling 12 months sum

In a chart you can use the rangesum function to get the rolling sum.

rangesum(above(sum(Sales),0,12))

Highlighted

Re: How to do rolling 12 months sum

May be like this:

Dimension

MonthYear

Expression

Rangesum(Above(Sum({<MonthYear>}Amount),0,12)) * Avg(1)

Highlighted
Not applicable

Re: How to do rolling 12 months sum

I have a question. Is there a chance to sum lateral instead of above? from right to left?

Highlighted

Re: How to do rolling 12 months sum

In a pivot table? You can use Before/After

Missing Manual - Before() and After()