https://community.qlik.com/t5/App-Development/Need-help-summing-values-in-multiple-rows-between-two-dates/m-p/2113818#M90928 <P>I have the below table.&nbsp; I would like to sum all the rows in column C (TIME GAP MINUTES) between each SHIFT_START_TIME (Column D) and group by shift start time.&nbsp; The dates can sometimes span over 2 different calendar dates if a user is working night shift.&nbsp;&nbsp;</P> <P>I have tried using the Peek and Previous functions with no luck. Does anyone have a good solution to cumulating values?</P> <P>I appreciate any help/insight. TY!&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="qlik_help.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115709i51AE2226C86E695E/image-size/large?v=v2&amp;px=999" role="button" title="qlik_help.png" alt="qlik_help.png" /></span></P> Tue, 05 Sep 2023 19:16:26 GMT mwilkinson11 2023-09-05T19:16:26Z https://community.qlik.com/t5/App-Development/Need-help-summing-values-in-multiple-rows-between-two-dates/m-p/2113818#M90928 <P>I have the below table.&nbsp; I would like to sum all the rows in column C (TIME GAP MINUTES) between each SHIFT_START_TIME (Column D) and group by shift start time.&nbsp; The dates can sometimes span over 2 different calendar dates if a user is working night shift.&nbsp;&nbsp;</P> <P>I have tried using the Peek and Previous functions with no luck. Does anyone have a good solution to cumulating values?</P> <P>I appreciate any help/insight. TY!&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="qlik_help.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115709i51AE2226C86E695E/image-size/large?v=v2&amp;px=999" role="button" title="qlik_help.png" alt="qlik_help.png" /></span></P> Tue, 05 Sep 2023 19:16:26 GMT https://community.qlik.com/t5/App-Development/Need-help-summing-values-in-multiple-rows-between-two-dates/m-p/2113818#M90928 mwilkinson11 2023-09-05T19:16:26Z