topic Re: Interval match in QlikView

Interval match

bimanbeginner — Wed, 25 Nov 2020 16:16:04 GMT

I have one table.

Schedule:

Load

[Schedule Start],

[Schedule End]

From Schedules:

This time format of both fields is 'YY/MM/DD hh:mm:ss'

I need to find all the times between the start and end time eg:

[Schedule Start]=17/06/13 13:33:00

[Schedule End] =17/06/13 13:36:00

I would like my field to return :

TimeRange field:

17/06/13 13:33:00

17/06/13 13:34:00

17/06/13 13:35:00

My point is to show how long my schedule was running down to the minute level and maybe another field going to second level.

if there is an easier way to do this other than an interval match please advise.

Thank You

Re: Interval match

sunny_talwar — Tue, 13 Jun 2017 11:04:35 GMT

May be use a while loop here:

Loops in the Script

Re: Interval match

sunny_talwar — Tue, 13 Jun 2017 11:08:52 GMT

Sample script

Table:

LOAD *,

TimeStamp(Schedule_Start + ((IterNo()-1)/(24*60))) as TimeRange

While Schedule_Start + (IterNo()/(24*60)) <= Schedule_End;

LOAD * INLINE [

Schedule_Start, Schedule_End

17/06/13 13:33:00, 17/06/13 13:36:00

];

Re: Interval match

bimanbeginner — Tue, 13 Jun 2017 11:54:32 GMT

Thank You , if I wanted to go down to seconds would I Do the below?

Table:

LOAD *,

TimeStamp(Schedule_Start + ((IterNo()-1)/(24*3600))) as TimeRange

While Schedule_Start + (IterNo()/(24*3600)) <= Schedule_End;

LOAD * INLINE [

Schedule_Start, Schedule_End

17/06/13 13:33:00, 17/06/13 13:36:00

];

Re: Interval match

sunny_talwar — Tue, 13 Jun 2017 12:07:10 GMT

Yes, you got the trick