YTD Cumulative with zero values

Anonymous — Fri, 03 Feb 2017 09:26:35 GMT

Hi Guys,

I need a set analysis calculation Cumulative value YTD with zero values. Here is de sample dataset and how is calculated. When selecting on the time field this shouldn't be changing. The cumulative starts again after one year...

pls advice thanks!

Robbie

Time	Value	Cumulative value YTD
jan-16	10	10
feb-16	11	21
mrt-16	16	37
apr-16	80	117
mei-16	0	117
jun-16	0	117
jul-16	90	207
aug-16	5	212
sep-16	60	272
okt-16	4	276
nov-16	5	281
dec-16	8	289
jan-17	80	80
feb-17	75	155

Re: YTD Cumulative with zero values

sunny_talwar — Fri, 03 Feb 2017 09:29:37 GMT

If those values are not missing, you can try this:

Aggr(RangeSum(Above(Sum(Value), 0, RowNo())), YearField, Time)

Make sure to replace YearField with Year field in your database

topic YTD Cumulative with zero values in QlikView

YTD Cumulative with zero values

Re: YTD Cumulative with zero values