Time function create a row for every 5 minutes from startTime to endtime

[#1]

Hi,

I have a file with a unique ID , start and end time. I want to do a interval match but I want the time interval to be every 5 minute.

so I need qlikview to create new row for every 5 minutes from startTime to endtime and stop when endtime is reached

So If I have a Starttime and Endtime

Starttime 13:00 and Endtime 13:30 I want qlikview to create a row for every 5 minuter like so

ID, StartTime, EndTime

1,13:00 ,13:30

1,13:05 ,13:30

1,13:10 ,13:30

1,13:15 ,13:30

1,13:20 ,13:30

1,13:25 ,13:30

Any ideas?

thx

[sunny_talwar · Accepted solution]

May be this:

Table:

LOAD *,

  Time(StartTime + MakeTime(0, 5) * (IterNo() - 1)) as Time

While StartTime + MakeTime(0, 5) * (IterNo() - 1) <= EndTime;

LOAD * INLINE [

    ID, StartTime, EndTime

    1, 13:00:00, 13:30:00

    2, 12:00:00, 12:20:00

    3, 12:40:00, 12:55:00

];

[#3]

Thx again Sunny, you are a true wizard!