topic Solved in QlikView

Solved

microwin88x — Wed, 04 Nov 2015 18:17:56 GMT

Hello,

I have the following table with fields PERIOD and AMOUNT:

I need to calculate the fields ACUM and OP by script where:

ACUM for 201301 is 448, ACUM for 201302 is 448+390=838, ACUM for 201303 is 448+390+499=1337

OP for 201301 is 448/01, OP for 201302 is 838/02, OP for 201303 is 1337/03

Do you know how could I do this?

Thank you!

Solved

Chanty4u — Wed, 04 Nov 2015 18:22:13 GMT

hi,

RangeSum(Above(TOTAL Sum(PERIOD), 0, RowNo(TOTAL)))/sum(total AMOUNT)

RangeSum(Above(TOTAL Sum(PERIOD), 0, RowNo(TOTAL)))/sum(total PERIOD)

hope this helps you

thanks

suresh

sunny_talwar — Wed, 04 Nov 2015 18:24:05 GMT

Try this:

Table:

LOAD *,

YEAR(PERIOD) as YEAR,

Num(Month(PERIOD)) as MONTH;

LOAD Date#(PERIOD, 'YYYYMM') as PERIOD,

AMOUNT

FROM

[https://community.qlik.com/thread/190352]

(html, codepage is 1252, embedded labels, table is @1);

FinalTable:

LOAD *,

ACUM/MONTH as OP;

LOAD *,

If(YEAR = Peek('YEAR'), RangeSum(PEEK('ACUM'), AMOUNT), AMOUNT) as ACUM

Resident Table;

DROP Table Table;