Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
sunny_talwar

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

];

View solution in original post

2 Replies
sunny_talwar

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

];

View solution in original post

Not applicable
Author

Thx again Sunny, you are a true wizard!