Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Creating rolling 12 value depending on month


I have a graph with monthly values (last 24 month - working fine) and rolling 12 values (picture 1) and its OK when no selection of month. But when I select a month the rolling values only shows on the selected month (picture 2). I would like to present the rolling 12 to the selected month and then 12 month back.

and if possible show the data for a 24 month period as the monthly value

Today I use the following syntax with :

sum( aggr( rangesum( above( sum( {$<[YearMonth]>}  Revenue),0,12) ),[YearMonth]))

1 Reply
MVP & Luminary
MVP & Luminary

Re: Creating rolling 12 value depending on month

Check this link.

How to do rolling 12 months sum


Kaushik Solanki

If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".