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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Split Time Interval

Dear All,

in my Script I would like to split a time interval into parts.

What I have:

Begin: 08:52:31

End: 10:31:40

Duration: 01:39:09

What I want:

...

Interval 07:00 to 08:00 --> 00:00:00

Interval 08:00 to 09:00 --> 00:07:29

Interval 09:00 to 10:00 --> 01:00:00

Interval 10:00 to 11:00 --> 00:31:40

Interval 11:00 to 12:00 --> 00:00:00

...

Thanks a lot

Tim

1 Solution

Accepted Solutions
hector
Specialist
Specialist

Hi, i've made this. check it out and tell me if works. Look the "calc_result" field

rgds

View solution in original post

2 Replies
hector
Specialist
Specialist

Hi, i've made this. check it out and tell me if works. Look the "calc_result" field

rgds

Not applicable
Author

Hi Héctor,

thanks a lot! That pretty much did it!

Schönen Gruß

Tim