Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-09-30 04:25 PM

grouping data

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.

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?  Do I use the load statement for that? 

I'm a complete novice and appreciate your help!

205 Views
0 Likes
1 Reply
marcus_sommer
MVP
MVP
‎2015-09-30 09:37 PM

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: How to use - Master-Calendar and Date-Values.

- Marcus

138 Views
0 Likes