Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
nesonica
New Contributor III

Rolling 12-months since last month

Hi guys,

I would like to show Sales as standard for the sum of the last month until the last 12 months before that.

i know have it on a yearly level:

 

=Sum({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'}>} Sales)

Labels (2)
1 Solution

Accepted Solutions
bobbydave
Contributor III

Re: Rolling 12-months since last month

=Sum({<PeriodMath={'>=$(=Monthstart(addmonths(max(Today()),-11)))<=$(Monthstart(addmonths(max(Today()),-1))'}>} Sales)

1 Reply
bobbydave
Contributor III

Re: Rolling 12-months since last month

=Sum({<PeriodMath={'>=$(=Monthstart(addmonths(max(Today()),-11)))<=$(Monthstart(addmonths(max(Today()),-1))'}>} Sales)