topic Re: Create intervals between a range in App Development

Create intervals between a range

jpapador — Wed, 23 Nov 2016 20:36:28 GMT

I have a start time and a stop time what I'd like to do is create records for every hour in between.

For example:

Current:

Record Num	Start Time	Stop Time
1	10:00	13:27

What I want

Record Num

Hour interval

10:00

11:00

12:00

13:00

13:27

Re: Create intervals between a range

sunny_talwar — Wed, 23 Nov 2016 20:56:02 GMT

May be try this:

Table:

LOAD [Record Num],

Time(RangeMin(Round([Start Time] - MakeTime(1) + MakeTime(IterNo()), 1/24), [Stop Time])) as [Hour Interval]

While Round([Start Time] - MakeTime(1) + MakeTime(IterNo()), 1/24) < [Stop Time] + MakeTime(1);

LOAD * INLINE [

Record Num, Start Time, Stop Time

1, 10:00, 13:27

];

Re: Create intervals between a range

maxgro — Wed, 23 Nov 2016 21:03:46 GMT

LOAD

[Record Num],

[Start Time],

[Stop Time],

Time([Start Time] + 1/24 * (iterno()-1)) as Hour

FROM

[https://community.qlik.com/thread/240846]

(html, codepage is 1252, embedded labels, table is @1)

While [Start Time] + 1/24 * (iterno()-1) <= [Stop Time]

;

Concatenate (X)

First 1

LOAD

[Record Num],

[Start Time],

[Stop Time],

0+[Stop Time] as Hour

FROM

[https://community.qlik.com/thread/240846]

(html, codepage is 1252, embedded labels, table is @1)

;

Re: Create intervals between a range

shah101 — Thu, 12 May 2022 21:11:32 GMT

Hi ,

Sunny_talwar I tried you formula to create the interval and it worked for me but I need some help to create 30 minutes interval instead of 1 hour. I made some changes into the code and was able to create the interval for 24 hours.

Table:

LOAD [DateTime],

Time(RangeMin(Round([Start Time] - MakeTime(1) + MakeTime(IterNo()), 1/24), [Stop Time])) as [Hour Interval]

While Round([Start Time] - MakeTime(1) + MakeTime(IterNo()), 1/) < [Stop Time] + MakeTime(1);

LOAD * INLINE [

DateTime, Start Time, Stop Time

any help will be appreciated!

1, 00:00, 23::30

];