https://community.qlik.com/t5/App-Development/accumulate-daily/m-p/2427092#M96235 <P>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:</P> <PRE>RangeSum(Above(Sum(Erzeugung), 0, Hour([Timestamp_stündlich]) + 1))</PRE> <P>&nbsp;</P> Tue, 05 Mar 2024 11:45:58 GMT LRuCelver 2024-03-05T11:45:58Z https://community.qlik.com/t5/App-Development/accumulate-daily/m-p/2426968#M96233 <P>Hello,&nbsp;</P> <P>i have a diagramm (Screenshot).</P> <P>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).</P> <P>RangeSum(Above(Sum(Erzeugung), 0, date(left([Timestamp_stündlich],10))))</P> <P>--&gt;&nbsp;date(left([Timestamp_stündlich],10) is the date</P> <P>Please help! Thanks Oliver</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="OS92_0-1709628077021.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161291iE03DEAA3166A88A5/image-size/medium?v=v2&amp;px=400" role="button" title="OS92_0-1709628077021.png" alt="OS92_0-1709628077021.png" /></span></P> <P>&nbsp;</P> Tue, 05 Mar 2024 08:44:57 GMT https://community.qlik.com/t5/App-Development/accumulate-daily/m-p/2426968#M96233 OS92 2024-03-05T08:44:57Z https://community.qlik.com/t5/App-Development/accumulate-daily/m-p/2427092#M96235 <P>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:</P> <PRE>RangeSum(Above(Sum(Erzeugung), 0, Hour([Timestamp_stündlich]) + 1))</PRE> <P>&nbsp;</P> Tue, 05 Mar 2024 11:45:58 GMT https://community.qlik.com/t5/App-Development/accumulate-daily/m-p/2427092#M96235 LRuCelver 2024-03-05T11:45:58Z