topic Re: Calculate Cumulative Sales in Script in QlikView

Calculate Cumulative Sales in Script

Tue, 28 Oct 2014 11:47:47 GMT

I am trying to get the cumulative sales per Booking Date per Service Month.

Please see below...

I am trying to get field 'Cumulative Sales' ..

Any suggestions will be appreciated.

Regards,

Magen

Tue, 28 Oct 2014 12:29:04 GMT

Hi,

try this it would be helpful to you

Load *,numsum(Sales+peek([Cumm Sales]) as [Cumm Sales]

resident Table;

maxgro — Tue, 28 Oct 2014 12:43:39 GMT

tmp:

LOAD [Service Month], date(date#([Booking Date],'YYYY-MM-DD')) as [Booking Date], Sales, [Cumulative Sales]

FROM [http://community.qlik.com/thread/139744] (html, codepage is 1252, embedded labels, table is @1);

final:

load

if(peek([Service Month])<>[Service Month], Sales, Sales + peek(NewCumSales)) as NewCumSales

Resident tmp

order by [Service Month], [Booking Date];

DROP Table tmp;

ashfaq_haseeb — Tue, 28 Oct 2014 13:10:27 GMT

Hi,

Check for my solution in the below link.

Regards

ASHFAQ

anbu1984 — Tue, 28 Oct 2014 13:18:10 GMT