Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mwilkinson11
Contributor
Contributor
‎2023-09-05 03:16 PM

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)
Labels
242 Views
0 Likes
0 Replies