How to count amount for date?

[stantrolav]

http://community.qlik.com/docs/DOC-5551

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 · Accepted solution]

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]

Cool. Thanks.