Analyzing time in QlikView | Qlik Community

Analyzing  time in QlikView | Qlik Community: "Accidents:
LOAD * INLINE [
AcID, AcDat, AcTime
1, 1/1/2010, 8:01:00
2, 1/7/2010, 9:10:11
3, 2/1/2011, 13:00:00
4, 3/4/2011, 17:00:00
];

Bucket:
LOAD * INLINE [
TimeFrom, TimeTo, TimeDesc
00:00:01, 09:00:00, Morning
09:01:01, 16:00:00, Day
16:00:01, 23:59:59, Evening
];

LEFT Join (Accidents)
IntervalMatch(AcTime)
LOAD TimeFrom, TimeTo RESIDENT Bucket;

LEFT Join (Accidents)
LOAD * RESIDENT Bucket;

DROP Table Bucket;"



'via Blog this'