topic Re: Time function create a row for every 5 minutes from startTime to endtime in QlikView

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

Tue, 11 Apr 2017 12:24:53 GMT

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 — Tue, 11 Apr 2017 12:44:28 GMT

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

];

Wed, 12 Apr 2017 13:58:49 GMT

Thx again Sunny, you are a true wizard!