topic Accumulated Sum - Straight Table in QlikView

Accumulated Sum - Straight Table

pamaxeed — Tue, 14 Nov 2017 19:48:07 GMT

Hi all,

I need help with the above function.

I have following straight table:

The relevant column ist TWR YTD, which should reflect the accumulated SUM from TWR Täglich.

The logic should be adjusted here with following requirements

Acc Sum by ID and ISIN
If Flag IstBeginn = 1 we should start to sum up from 0

In this case the red underlined values should be all 0 as we do not have any specific value in TWR Täglich column.

I used the following function:

Rangesum( above(total Column(6),0,rowno(total)))

We have to tweak with the last 2 parameters and maybe use the AGGR function by grouping the resultset by ID and ISIN (not sure if needed).

Is there anyone who can support me here?

Thanks,

Patric

Re: Accumulated Sum - Straight Table

sunny_talwar — Tue, 14 Nov 2017 19:51:12 GMT

Have you tried this?

RangeSum(Above(Column(6), 0, RowNo()))

Re: Accumulated Sum - Straight Table

sunny_talwar — Tue, 14 Nov 2017 19:52:42 GMT

You might have to create a new field in the script like this

LOAD Id*ISIN as Key

and then try like this

Aggr(RangeSum(Above(Column(6), 0, RowNo())), Ket, DateField)

Re: Accumulated Sum - Straight Table

pamaxeed — Tue, 14 Nov 2017 19:57:09 GMT

Looks good!

Can you explain me what is the difference to mine one?

Thanks!

Re: Accumulated Sum - Straight Table

sunny_talwar — Wed, 15 Nov 2017 09:31:22 GMT

By design when you add TOTAL to Above and RowNo, they accumulative regardless of the chart dimension... where as without TOTAL, the value changes based on dimension change.