Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
aliyoung92
Contributor III
Contributor III

Cumulative Sum that doesn't fill future months

Hi

I'm trying to create a pivot with a cumulative sum based on current and previous financial year and split between periods.

The previous year works great with the below expression, however the current year fills the future periods with the same value as the last month of data as there is no data yet in the system.

Could someone provide a solution how to stop periods with no data copying what is in the previous period.

I.e. April displays £15m and then all the periods after do also as I believe it is just looking at the previous period and trying to add an additional value.

=rangesum(before(Sum({$<Grouping={"Income"}>}Actual),0,columnNo()))*-1

Thanks

3 Replies
sunny_talwar

May be this

=If(Sum({$<Grouping={"Income"}>}Actual) > 0, RangeSum(Before(Sum({$<Grouping={"Income"}>} Actual), 0, ColumnNo()))*-1)

beck_bakytbek
Master
Master

Hi Alistair,

look at this: https://www.youtube.com/watch?v=zIVj4U9QqPQ

i hope that helps

Beck

aliyoung92
Contributor III
Contributor III
Author

Thanks Sunny this helped me out.