topic Re: Accumulating over one dimension in QlikView

Accumulating over one dimension

Thu, 18 Feb 2016 20:14:17 GMT

Hi guys, probably an easy one.

Given this table:

I need to accumulate the measure Vekt pr row pr KODE. THe first row is added to the second, the new second value is added to the third. And so forth. But on RowNo = 25 (new KODE) it should start over again.

Pls advice.

See attached documents.

Best regards

Trond E

Re: Accumulating over one dimension

sunny_talwar — Thu, 18 Feb 2016 21:58:11 GMT

Try this:

Aggr(RangeSum(Above(Sum(Vekt),0, RowNo())), KODE, RowNO)

Change in Script:

Table:

LOAD RowNo() as RowNO,

KODE as KODE1,

EmneKode,

Rangering,

[=FUNNET_VEKT] as Vekt,

[=EmneKode]

FROM

[CH08_20160218_170244.xls]

(biff, embedded labels, table is Sheet1$);

FinalTable:

LOAD RowNO,

KODE1 as KODE,

EmneKode,

Rangering,

Vekt,

[=EmneKode]

Resident Table

Order By KODE1;

DROP Table Table;

Output:

Re: Accumulating over one dimension

Thu, 18 Feb 2016 22:03:32 GMT

Thank you very much!

Best regards

Trond Erik

Re: Accumulating over one dimension

rubenmarin — Thu, 18 Feb 2016 22:20:42 GMT

There is also a chart solution, at least for straight table (where you can hide columns)