This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!
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