Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dairan73
Contributor III
Contributor III

Sort the time in the time group

I need help to sort the time (UsedTime) in the time group, for example:

Time Groups:

07:00 to 12:59

13:00 to 18:59

19:00 to 22:59

23:00 to 06:59

2017-04-24 - 001.png

Example: Cod 111 have the total time of 02:45, but 44 minutes need to join the group 13:00 to 18:59 and 2hours and 1 minute to the group 19:00 to 22:59.

Can someone help me?

Thank you.

11 Replies
dairan73
Contributor III
Contributor III
Author

But with the intervalmatch I can't put the minutes of the same Cod in more than one group (Look at the image of the answer above).

sunny_talwar

Got it this far

Capture.PNG

Did not get the time to fix the Cod 555, may be someone else can take it forward from here