Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a start time and a stop time what I'd like to do is create records for every hour in between.
What I want
Go to Solution.
Time([Start Time] + 1/24 * (iterno()-1)) as Hour
(html, codepage is 1252, embedded labels, table is @1)
While [Start Time] + 1/24 * (iterno()-1) <= [Stop Time]
0+[Stop Time] as Hour
View solution in original post
May be try this:
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