Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: creating values for the time in between

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

Creating Reference Dates for Intervals

IntervalMatch

- Marcus