topic Aggregate data for the last 12 months in QlikView

Aggregate data for the last 12 months

david_ze — Tue, 18 Dec 2012 19:31:30 GMT

Hi All,

I'll appreciate your prompt assistance on an issue I have.

I have a table which has the following fields:

Date, Transaction_Type, Amount

I would like to aggregate the last 12 months amount for each Transaction_Type on a monthly basis

i.e

for the 31/01/2012 the sum of the amount from 1/2/2011 to 31/01/2012

for the 28/2/2012 the sum of the amount from 1/3/2011 to 28/2/2012

all of this should be for each Transaction_Type.

Thanks in advance.

David

Re: Aggregate data for the last 12 months

francisvandergr — Tue, 18 Dec 2012 20:58:18 GMT

You can work with accumulation at the expressions tab i think. Otherwise you have an example ?

Re: Aggregate data for the last 12 months

david_ze — Wed, 19 Dec 2012 04:05:18 GMT

I would like to do this within the script

Re: Aggregate data for the last 12 months

nirav_bhimani — Wed, 19 Dec 2012 07:11:58 GMT

Hi,

try this expression, It will show the result as you want.

sum ({ <InvoiceDate = P( { <InvoiceDate ={">=$(=(Max(InvoiceDate)-365) ) <= {<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=Month(Max(InvoiceDate)))}>}"}>} ) >} InTotRs)

Regards,

Nirav Bhimani

Re: Aggregate data for the last 12 months

david_ze — Wed, 19 Dec 2012 13:49:23 GMT

within the script please

Re: Aggregate data for the last 12 months

Fri, 31 Oct 2014 14:30:17 GMT

HI David,

Can you Give the me the Solution Which I got the Same Req, Right now, Can you please help me on this....

Regards,

Helen