topic Re: conditional cumulative sum in QlikView

?

xyz1 — Sun, 14 Apr 2019 16:24:09 GMT

Re: conditional cumulative sum

xyz1 — Sun, 14 Apr 2019 10:46:25 GMT

Re: conditional cumulative sum

sunny_talwar — Tue, 30 Jan 2018 13:41:17 GMT

Looks good... is it not working for you?

Re: conditional cumulative sum

xyz1 — Sun, 14 Apr 2019 10:47:19 GMT

Re: conditional cumulative sum

sunny_talwar — Wed, 31 Jan 2018 12:19:14 GMT

You are saying we are in March? Are we really in March? I am not sure I understand how can we be in March when it is only January? I am not sure I follow what is incorrect here.

Re: conditional cumulative sum

xyz1 — Sun, 14 Apr 2019 10:45:39 GMT

Re: conditional cumulative sum

sunny_talwar — Thu, 01 Feb 2018 12:39:33 GMT

Can you just provide me the numerical output you are looking to get in a Excel file? I understand the logic, but I am not sure what isn't working.

Re: conditional cumulative sum

xyz1 — Sun, 14 Apr 2019 10:47:49 GMT

Re: conditional cumulative sum

sunny_talwar — Fri, 02 Feb 2018 12:30:23 GMT

Try this

RangeSum(Above(If(Month(Months) <= Month(Today()), (Sum({$<[type]={'Actual GFC'}>} value)), (sum({$<[type]={'Forecast GFC'}>} value))), 0, RowNo()))

RangeSum(Above(If(Month(Months) <= Month(Today()), (Sum({$<[type]={'Actual CAPEX'}>} value)), (Sum({$<[type]={'Forecast CAPEX'}>} value))), 0, RowNo()))

So, instead of rangesumming the individual expression, rangesum the whole if statement