topic Average for Last 12 months in QlikView

Average for Last 12 months

raviityou — Tue, 23 Feb 2016 18:37:22 GMT

Hi ALL,

I am trying to calculated the last 12 month average sales

With the following expression =

RangeSum( Before( Sum({<FKART = {'ZC07', 'ZS1'}, Flag = {'2'}, KPI = {'SalesDomesticAnalysis'},Fiscal_Year=>} MENGE),0,13))/12

With this expression values get reflected but I want to show only when last 12 values is available, suppose I have data from jan 2014 to march 2015 then the output value should get reflect only onward from jan 2015.

Values should not reflect for jan 2014 to dec 2014.

Please find attached sample data and expected result.

Re: Average for Last 12 months

Chanty4u — Wed, 24 Feb 2016 05:59:31 GMT

chk dis

Calculating rolling n-period totals, averages or other aggregations

Re: Average for Last 12 months

Anonymous — Wed, 24 Feb 2016 07:50:00 GMT

First Use Cross Load to transform this excel table, see this?

The Crosstable Load

Then this would help you?

Calculating rolling n-period totals, averages or other aggregations

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

Re: Average for Last 12 months

raviityou — Wed, 24 Feb 2016 18:12:26 GMT

Thanks for response,

But how can i show value only onward Jan 2015.

I have min Date is Jan 2014 and i want to show only last 12 month average mean Sum( form Jan 2014 to Jan 2015 )/12

into Jan 2015 column before it all column should be empty.

Re: Average for Last 12 months

Anonymous — Thu, 25 Feb 2016 05:26:59 GMT

Could you share a sample data?

Re: Average for Last 12 months

raviityou — Thu, 25 Feb 2016 10:43:56 GMT

Hi Balraj

I have attached sample excel data with expected result. once again i am attached sample data.