Rolling 12 month chart

Thu, 23 Apr 2015 20:23:34 GMT

Hi,

I can use the forum’s help with a rolling 12 month chart I am trying to create.

I wish to generate a line chart showing the sum of profit for the rolling 12 month for multiple countries on the same line chart.

After reading through the forum I attempted to do the following:

sum( aggr( rangesum( above( sum( {$<Time>} Profit),0,12) ),Time,Country))

But the results I’m getting have nothing to do with what I was hoping for.

When I use the following expression:

sum( aggr( rangesum( above( sum( {$<Time>} Profit),0,12) ),Time))

I get the right results only when I chose one of the countries. When more than one country is selected I get the sum of the profit for the countries on one line.

I’m not sure what I’m doing wrong here. Unfortunately I don’t have access to the script.

Any help will be appreciated.

Once the chart get the right data I would also like to present only data for months that have actual sum of 12 month (i.e. not show the first 11 months as data point). But this is more of a “nice to have”

I’m attaching mock qvw file to help explain what I’m try to do.

Thanks in advance,

I tried looking here:

Calculating rolling n-period totals, averages or other aggregations

and here:

Accumulative Sums

But couldn't figure it out.

Re: Rolling 12 month chart

Fri, 24 Apr 2015 02:30:02 GMT

Hi try this expression:

sum( aggr( rangesum( above( sum( {$<Time>} Profit),0,12) ),Country,Time))

Re: Rolling 12 month chart

Fri, 24 Apr 2015 14:46:32 GMT

Thanks. It works

Re: Rolling 12 month chart

Fri, 24 Apr 2015 20:21:48 GMT

ur welcome! please mark the reply as correct and close the thread since the question is solved. thanks!

topic Re: Rolling 12 month chart in QlikView

Rolling 12 month chart

Re: Rolling 12 month chart

Re: Rolling 12 month chart

Re: Rolling 12 month chart