Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
robbiewottie
Contributor III
Contributor III

YTD Cumulative with zero values

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

   

TimeValueCumulative value YTD
jan-161010
feb-161121
mrt-161637
apr-1680117
mei-160117
jun-160117
jul-1690207
aug-165212
sep-1660272
okt-164276
nov-165281
dec-168289
jan-178080
feb-1775155
1 Reply
sunny_talwar

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