topic grouping data in QlikView https://community.qlik.com/t5/QlikView/grouping-data/m-p/973764#M967155 <HTML><HEAD></HEAD><BODY><P>I have data sorted by date in 15 minute increments. Date and time are separate fields. Time increments are 00:00 - 00:14, 00:15-00:29, etc., all the way to 23:45 - 23:59.</P><P></P><P>Is it possible to combine these increments into hours, so that the first four increments of the day will be combined into 00:00 - 00:59?&nbsp; Do I use the load statement for that?&nbsp; </P><P></P><P>I'm a complete novice and appreciate your help!</P></BODY></HTML> Wed, 30 Sep 2015 20:25:39 GMT 2015-09-30T20:25:39Z grouping data https://community.qlik.com/t5/QlikView/grouping-data/m-p/973764#M967155 <HTML><HEAD></HEAD><BODY><P>I have data sorted by date in 15 minute increments. Date and time are separate fields. Time increments are 00:00 - 00:14, 00:15-00:29, etc., all the way to 23:45 - 23:59.</P><P></P><P>Is it possible to combine these increments into hours, so that the first four increments of the day will be combined into 00:00 - 00:59?&nbsp; Do I use the load statement for that?&nbsp; </P><P></P><P>I'm a complete novice and appreciate your help!</P></BODY></HTML> Wed, 30 Sep 2015 20:25:39 GMT https://community.qlik.com/t5/QlikView/grouping-data/m-p/973764#M967155 2015-09-30T20:25:39Z Re: grouping data https://community.qlik.com/t5/QlikView/grouping-data/m-p/973765#M967156 <HTML><HEAD></HEAD><BODY><P>I think you could use class(minutes(YourTimeField), 15) or ceil(minutes(YourTimeField) / 15) to group the minutes and used further fields like hour(YourTimeField). I suggest this not to make within the fact-table (especially if they is larger) else to use master-calendar and master-time-table, see: <A href="https://community.qlik.com/docs/DOC-8843">How to use - Master-Calendar and Date-Values</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 01 Oct 2015 01:37:18 GMT https://community.qlik.com/t5/QlikView/grouping-data/m-p/973765#M967156 marcus_sommer 2015-10-01T01:37:18Z