topic Grouping date field into hours in App Development https://community.qlik.com/t5/App-Development/Grouping-date-field-into-hours/m-p/98940#M6575 <HTML><HEAD></HEAD><BODY><P>I have a date field in qlik sense, [completed_date], that includes all times of the day as number.&nbsp; I can convert these to day by using Date function, but am trying to figure out if there is a way to group this field by hour. I have used the Hour function, but that does not return the correct information, rather it groups all the days together, then groups by hour.&nbsp; I tried Date(hour([completed_date])) but, similar results.&nbsp; I really just want this new dimension to group each day by hour, so I can see, lets say, 9/21/2018 4:00, 9/21/2018 3:00, 9/21/2018 2:00, and so on.&nbsp; Is there an expression that can be used to achieve this?&nbsp; Thanks in advance for help.</P></BODY></HTML> Fri, 21 Sep 2018 20:34:37 GMT Anonymous 2018-09-21T20:34:37Z Grouping date field into hours https://community.qlik.com/t5/App-Development/Grouping-date-field-into-hours/m-p/98940#M6575 <HTML><HEAD></HEAD><BODY><P>I have a date field in qlik sense, [completed_date], that includes all times of the day as number.&nbsp; I can convert these to day by using Date function, but am trying to figure out if there is a way to group this field by hour. I have used the Hour function, but that does not return the correct information, rather it groups all the days together, then groups by hour.&nbsp; I tried Date(hour([completed_date])) but, similar results.&nbsp; I really just want this new dimension to group each day by hour, so I can see, lets say, 9/21/2018 4:00, 9/21/2018 3:00, 9/21/2018 2:00, and so on.&nbsp; Is there an expression that can be used to achieve this?&nbsp; Thanks in advance for help.</P></BODY></HTML> Fri, 21 Sep 2018 20:34:37 GMT https://community.qlik.com/t5/App-Development/Grouping-date-field-into-hours/m-p/98940#M6575 Anonymous 2018-09-21T20:34:37Z Re: Grouping date field into hours https://community.qlik.com/t5/App-Development/Grouping-date-field-into-hours/m-p/98941#M6576 <HTML><HEAD></HEAD><BODY><P>Use a rounding function like Round(), Floor() or Ceil():</P><P></P><P>Timestamp(Round(TIMESTAMPFIELD, Maketime(1))) as RoundedToHourTimestamp</P></BODY></HTML> Fri, 21 Sep 2018 20:39:31 GMT https://community.qlik.com/t5/App-Development/Grouping-date-field-into-hours/m-p/98941#M6576 swuehl 2018-09-21T20:39:31Z Re: Grouping date field into hours https://community.qlik.com/t5/App-Development/Grouping-date-field-into-hours/m-p/98942#M6577 <HTML><HEAD></HEAD><BODY><P>Worked, thank you!</P></BODY></HTML> Fri, 21 Sep 2018 21:15:55 GMT https://community.qlik.com/t5/App-Development/Grouping-date-field-into-hours/m-p/98942#M6577 Anonymous 2018-09-21T21:15:55Z