New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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.

It must be like this.

Fatih Tomruk.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
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

6 Replies
Highlighted
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

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.

Aiolos

Highlighted
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

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

Highlighted
New Contributor III

Re: Cumulative sum by column

Thanks Aiolos, it works

Highlighted
New Contributor II

Re: Cumulative sum by column

what is [Tutar (UPB3)]???