Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Total of previous 11 month and actual date values

Hello I need to show in a chart 12 months columns, by which the last shown month would be the selected one.

And each of those month should be a sum of it and the 11 previous ones, that is called a TAM.

Ex;

Jun-2013 = values of the selected product in these dates

06/2013+05/2013+04/2013+03/2013+02/2013+01/2013+12/2012+11/2012+10/2012+09/2012+08/2012+07/2012



5 Replies

Re: Total of previous 11 month and actual date values

See this document: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
Not applicable

Re: Total of previous 11 month and actual date values

It is useful but doesn't apply for what i need, thank you very much.

Not applicable

Re: Total of previous 11 month and actual date values

Since Set Analysis is calculated once for the entire chart, you won't be able to do what you need with only one expression. You'd need to create a chart without dimensions and  12 expressions, and for each one use set analysis to set the min and max MonthYears you want to acumulate for it . For instance,

If you select June 2013:

June 2013: Jun 13 + May 13 + Apr 13 + Mar 13 + Feb 13 + Jan 13 + Dec 12 + Nov 12 + Sep 12 + Aug 12 + Jul12

May 2013  : May 13 + Apr 13 + Mar 13 + Feb 13 + Jan 13 + Dec 12 + Nov 12 + Sep 12 + Aug 12 + Jul12 + Jun 12

Apr 13       : Apr 13 + Mar 13 + Feb 13 + Jan 13 + Dec 12 + Nov 12 + Sep 12 + Aug 12 + Jul12 + Jun12 + May 12

and so on...

Hope it helps

Re: Total of previous 11 month and actual date values

Jun-2013 = values of the selected product in these dates

06/2013+05/2013+04/2013+03/2013+02/2013+01/2013+12/2012+11/2012+10/2012+09/2012+08/2012+07/2012

And May-2013 = ?

If it's 05/2013+04/2013+03/2013+02/2013+01/2013+12/2012+11/2012+10/2012+09/2012+08/2012+07/2012+06/2012 then you want is what I call a 12-month rolling total. In which case I wish you good luck doing this in any way that is not discussed in the document I referred to.


talk is cheap, supply exceeds demand
Not applicable

Re: Total of previous 11 month and actual date values

Yes May would look like that, here is an example made in excel so you can see:

DATA.bmp

I have 6 products, and 5 columns in this example.

Each column represents a sum of months.

Community Browser