topic SV:cummulative data in QlikView

cummulative data

Thu, 24 Jun 2010 12:13:25 GMT

Hi ,

Here my data and result is given below

Result

Please help me.

regards,

Aruensh

Thu, 24 Jun 2010 13:14:01 GMT

If you are showing it in a straight table check the complete ackumulation box on the expression (sum(amount).

Make sure your dimensions are sorted.

/Michael

Thu, 24 Jun 2010 13:25:24 GMT

thanks u support ..

But i want to built this logic in script and selection basis .

I wrote this script

Transactions:

LOAD

Plant

Plant1

Date

Amount

as Amount

(

numsum(Amount, peek([Cummulative Amount]))) as

[Cummulative Amount]

FROM

(

ooxml, embedded labels, table is Sheet1

)

but problem is that i cant group plant and date wise

regards,

Arunesh kumar

brenner_martina — Thu, 24 Jun 2010 15:37:03 GMT

Hi Arunesh,

the script looks like this:

Amount,

(Amount + If(Not IsNull(peek(Amount)),peek(Amount),0)) as [Cummulative Amount]