topic Split Time Interval in QlikView

Split Time Interval

Tue, 10 Nov 2009 23:11:45 GMT

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

hector — Wed, 11 Nov 2009 01:07:06 GMT

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

rgds

Fri, 13 Nov 2009 02:33:35 GMT

Hi Héctor,

thanks a lot! That pretty much did it!

Schönen Gruß

Tim