topic Re: 12 month rolling data in QlikView

12 month rolling data

guillaume_gorli — Tue, 31 Mar 2015 16:22:49 GMT

Here is a question that has probably already been asked although i did not find any accurate answer.

i am trying to build from a sales database a sales chart showing last 12 month sum up based on month selected.

Test Database looks like this :

So i would like to get from an expression the last 12 month based on the month and year selected.

i also need to add on the chart the same data but for the previous year so that on the same line i have Month sales as well as M-12 sales.

So, for instance, if February 2015 is selected, the output should be :

Attached is a sample app for the ones who want to help.

Thanks

Guillaume

Re: 12 month rolling data

MK_QSL — Tue, 31 Mar 2015 16:28:06 GMT

Kindly use this...

Calculating rolling n-period totals, averages or other aggregations

Re: 12 month rolling data

guillaume_gorli — Tue, 31 Mar 2015 17:05:17 GMT

Thanks Manish for the link. I had a look but it does not seem to be what i am looking for.

i am not looking a way to determine the sum of the last twelve month but a way to show the sum of the last twelve period separately.

For example, as i understand, the link you posted would help me to get below data for February 2015 as date selection :

Although what i am looking for is slightly different (see below) :

So if a period is selected, what i need is a simple sum of the last twelve period as well as, thanks to a second expression, the same data for the previous 12 month period.

Thus in the chart, Feb 2015 Sales are 19 shown on the same line as Feb 2014 sales which are 23.

Guillaume

Re: 12 month rolling data

guillaume_gorli — Wed, 01 Apr 2015 14:36:04 GMT

Any clue ?

Re: 12 month rolling data

MK_QSL — Wed, 01 Apr 2015 17:25:55 GMT

Check enclosed file...

Re: 12 month rolling data

guillaume_gorli — Thu, 02 Apr 2015 07:06:01 GMT

Thanks a lot Manish. That will help me a lot.

Guillaume

Re: 12 month rolling data

hubertdudek — Tue, 05 May 2015 11:02:53 GMT

Please check also this solution:

N-period rolling data, moving average, easy solution.