Hello,

Today, I’ll show you a clever technique to calculate the user defined time intervals. I’ll use the expression instead of field for calculated dimension.  I have learnt this technique fromRob Wunderlich on QlikView Community. So all credit to him for sharing this technique. Here is the expression of the calculated dimension and I’m sorry I can’t share the QVW file as I use the personal edition.

Aggr(
Dual(
(Time(Floor(MyTimeStamp, 1/IntervalSize), ‘h:mm TT’) & ‘ – ‘ & Time(Ceil(MyTimeStamp, 1/IntervalSize), ‘h:mm TT’)),
Floor(Frac(MyTimeStamp), 1/IntervalSize)),
MyTimeStamp)

I’ll demonstrate step-by-step process. Please contact me if you have any questions.

Just in case if you can’t watch the video from this site, you can use this link to watch from Youtube.

Thank you for watching. Happy learning.