topic Re: Cumulative sum by column in QlikView

Cumulative sum by column

fatihtomruk — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to make Balance Sheet on qlikview. But BS must be cumulative, not be single month.

Not like this. Because jan is correct but feb and the other months is montly, must be cumulative.

It must be like this.

Could you please help me?

Fatih Tomruk.

fatihtomruk — Tue, 16 Jan 2018 05:36:30 GMT

rangesum( above( sum([Tutar (UPB3)]),0,12) )

This formula is true when months on row but when put it on column, it is not true.

uacg0009 — Tue, 16 Jan 2018 06:36:25 GMT

Hi Faith,

Actually in Chart Properties, there is a function - Accumulation.

You can try to use Full Accumulation. And for expression, just use sum() is ok.

Please try, thanks.

Aiolos

fatihtomruk — Tue, 16 Jan 2018 06:55:04 GMT

Thanks Aiolos, but this is not for pivot or straight table.

When choose pivot table, this property is deactive.

uacg0009 — Tue, 16 Jan 2018 07:15:04 GMT

Hi Faith,

Yes, you are right, if you use pivot table, I think you can use this :

RangeSum(First(sum([Tutar (UPB3)]),1,ColumnNo()))

Thanks.

Aiolos

fatihtomruk — Tue, 16 Jan 2018 07:22:01 GMT

Thanks Aiolos, it works

pk — Sat, 30 Mar 2019 11:48:17 GMT

what is [Tutar (UPB3)]???