5 Replies Latest reply: Aug 10, 2018 12:27 PM by Sunny Talwar RSS

    Grouping times by hour

    Christopher Jackson

      Hi All,

       

      I have a report that I am working on where I have a date column and a time column for calls that were made. What I want to do is be able to group calls in a report by groups of hours. So basically I want to be able to see how many calls took place between 8am and noon, how many between 12pm and 5pm and how many from 5pm to 9pm.

       

      What's the best way for me to achieve this result in Qlikview? If possible I would like to be able to use these groupings as dimensions that can be selected from a list box and display them in a table as well.

       

      Edit: the times are already in military time with no need for am/pm.

       

      Thanks!