topic Running totals in two dimensional table in QlikView

Running totals in two dimensional table

Anonymous — Fri, 24 Nov 2017 11:55:58 GMT

Colleagues, i just posted discussion about calculation columnNo in two dimensional table:

and realized that when we use Total statement in ColumnNo(), it doesn't calculate running totals by each column.

Can anyone help to solve this thing?

Formula used in expression:

rangesum(before(sum(Sales),1,ColumnNo(total)-1))

stabben23 — Fri, 24 Nov 2017 12:30:49 GMT

aggr(rangesum(above( sum(Sales),0,rowno(total))),Date)

avkeep01 — Fri, 24 Nov 2017 12:47:24 GMT

Hi Staffan,

I came to the same conlusion. I've got the app attached.

AGGR(RANGESUM(ABOVE(SUM(Sales),0,ROWNO(TOTAL))),Date)

Anonymous — Fri, 24 Nov 2017 13:21:42 GMT

Thanks, colleagues!!!