topic Re: Cumulative MAT in table/chart in QlikView

Cumulative MAT in table/chart

Thu, 21 Nov 2013 08:32:59 GMT

Hi guys,

I need to have a column in this table that calculates MAT for each of the months.

So, in the March 2013 line of this table I need the sum of April 2012 to March 2013 and in the February 2013 I need the sum of March 2012 to February 2013.... and so on.

This table has data until 2010, but in the table/chart I only need the last 13 months.

Thank you in advance.

Kind regards,

Nuno

Re: Cumulative MAT in table/chart

bbi_mba_76 — Thu, 21 Nov 2013 08:54:57 GMT

Hi,

you could have a look at this document Calculating rolling n-period totals, averages or other aggregations

Re: Cumulative MAT in table/chart

Thu, 21 Nov 2013 09:20:08 GMT

Thanks. It seems it can only be solved by an AsOf table.

If someone has a different solution using a single expression directly in chart, I would really appreciate it.