Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cscliffe10x
New Contributor II

Null handling for RangeSum(Before(Total

Hello,

I am trying to create a cumulative sum and I am using the below formula.  I have NULL values for some months and would like to see the last value available (ie the current cumulative sum and not 0).  The goal is that after I have at least 1 quantity, all of the subsequent months will have a value and not be NULL.  Attached is my result set.  Thank you.

RangeSum(Before(TOTAL Sum([Quantity]), 0, ColumnNo()))

Community Browser