Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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!