topic Re: How to count amount for date? in QlikView

How to count amount for date?

stantrolav — Wed, 18 Dec 2013 08:53:47 GMT

How can i load field Amount for date in load script to get table like in this document. As input data may be used only first three fields.

swuehl — Wed, 18 Dec 2013 09:16:22 GMT

Try like this:

INPUT:

LOAD Agreement,

Date,

Amount

FROM

[AmountForDate.xlsx]

(ooxml, embedded labels, table is Лист1);

RESULT:

LOAD

Agreement,

Date,

Amount,

if(peek(Agreement)<>Agreement, Amount, rangesum(peek([Amount for Date]),Amount)) as [Amount for Date]

Resident INPUT order by Agreement, Date desc;

drop table INPUT;

stantrolav — Wed, 18 Dec 2013 10:11:31 GMT

Cool. Thanks.