Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

creating values for the time in between

Hi,

Thank you all for your help in advance.

I have a table that looks like:

Name     Start_Time     End_Time

--------     -----------------    -------------

Bob          1PM                    5PM

I am making a chart that should count all the time from start to end and represent each hour by +1 on a bar graph.

Per my example above, I am trying to make it so that the hours 1, 2, 3, 4, and 5 all have +1 in a bar graph.

Is this possible?


I thought about doing a loop, putting each hour into a new column then concatenating each new hour into my new column.
Any better ideas?

1 Reply
marcus_sommer

You could fill your data gaps with intervalmatch or a while-loop, see for example:

Creating Reference Dates for Intervals

IntervalMatch

- Marcus