accumulate daily

[OS92]

Hello, 

i have a diagramm (Screenshot).

i have a diagram with the following formula. this formula cumulates all values that are in the filtered selection. i would like to set the counter to 0 every day (midnight) and display the cumulated values for each day (current+past).

RangeSum(Above(Sum(Erzeugung), 0, date(left([Timestamp_stündlich],10))))

--> date(left([Timestamp_stündlich],10) is the date

Please help! Thanks Oliver

[LRuCelver]

Make sure your Timestamp is formatted as a timestamp and not as text in the datamodel. That way you can use all the date and time functions available in Qlik Sense:

RangeSum(Above(Sum(Erzeugung), 0, Hour([Timestamp_stündlich]) + 1))