Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Interval Match help....

Specifically trying to match the Start/End times against the EventID's/Dates  So that the Bandwidth fill in the TimeBin intervals rather than just the three time slots below. It should range up to i.e 1-24 or in this example 7-23 hours

Only shows the sum of the three. I want it to show over the start to end hour periods/intervals.

I'm open to suggestions. I may not need IntervalMatch

2013-11-19_130144.png

2013-11-19_130330.png

See attached table;

IntervalMatch:
IntervalMatch(hours)
LOAD

  StartTimeBin,
EndTimeBin
Resident [MidAtlantic];

Left Join(IntervalMatch)

Load
EventID,
StartTimeBin,
EndTimeBin
Resident [MidAtlantic];

Tags (1)