topic Re: Max Amount per Date Accumulated in QlikView

Max Amount per Date Accumulated

marcel_olmo — Tue, 03 Oct 2017 18:31:23 GMT

Hi guys,

I have a table like this :

And I'd like to get a result like this :

And I'd like to get an accumulate of the amounts in another table like this :

How can I get that?

Regards, Marcel.

swuehl — Tue, 03 Oct 2017 18:50:25 GMT

Why do you want the same constant date in the first column in your resulting table?

And what determines the four rows then ?

If that's a typo, order your table by Date and use Rangesum(Peek() ) combination for accumulation:

RESULT:

LOAD

Date,

Amount,

Rangesum(Amount, Peek(AccAmount)) as AccAmount

RESIDENT INPUT

ORDER BY Date;

DROP TABLE INPUT;

marcel_olmo — Wed, 04 Oct 2017 16:35:46 GMT

Thanks Stefan! That was it.

Regards, Marcel.