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

Hour of the day dimension

I have a field called SessionClosedTime, which is in the format HH:MMSmiley FrustratedS

How can I group these values into one hour ranges, so that I can display my data by hour?

2 Replies
MVP
MVP

Re: Hour of the day dimension

Create a field like:

Load

          Time(SessionClosedTime, 'hh') as Hour

Or,

Load

          Time(Time#(SessionClosedTime, 'hh:mm:ss'), 'hh') as Hour

er_mohit
Honored Contributor II

Re: Hour of the day dimension

interval(timesessionclosetimefield,'hh')