Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
We are aware of an issue with the Product Downloads page and looking into it.
cancel
Showing results for 
Search instead for 
Did you mean: 
mwilkinson11
Contributor
Contributor

Need help summing values in multiple rows between two dates.

I have the below table.  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.  The dates can sometimes span over 2 different calendar dates if a user is working night shift.  

I have tried using the Peek and Previous functions with no luck. Does anyone have a good solution to cumulating values?

I appreciate any help/insight. TY! 

qlik_help.png

Labels (1)
0 Replies