Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
fatihtomruk
New Contributor III

Cumulative sum by column

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.

Capture.PNG

It must be like this.

Capture1.PNG

Could you please help me?

Fatih Tomruk.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Cumulative sum by column

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

View solution in original post

6 Replies
Highlighted
fatihtomruk
New Contributor III

Re: Cumulative sum by column

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.

Highlighted
Partner
Partner

Re: Cumulative sum by column

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.

Cumulative sum by column.PNG

Please try, thanks.

Aiolos

Highlighted
fatihtomruk
New Contributor III

Re: Cumulative sum by column

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

When choose pivot table, this property is deactive.

Highlighted
Partner
Partner

Re: Cumulative sum by column

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

View solution in original post

fatihtomruk
New Contributor III

Re: Cumulative sum by column

Thanks Aiolos, it works

Highlighted
pk
New Contributor II

Re: Cumulative sum by column

what is [Tutar (UPB3)]???