Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fatihtomruk
Contributor III
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
uacg0009
Partner - Specialist
Partner - Specialist

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
fatihtomruk
Contributor III
Contributor III
Author

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
Partner - Specialist
Partner - Specialist

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

fatihtomruk
Contributor III
Contributor III
Author

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

When choose pivot table, this property is deactive.

uacg0009
Partner - Specialist
Partner - Specialist

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
Contributor III
Contributor III
Author

Thanks Aiolos, it works

pk
Contributor III
Contributor III

what is [Tutar (UPB3)]???