Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
GeosoftRim
Contributor III
Contributor III

time slots of the day


I want to define time slots of a quarter of an hour, that is to say from 00:00 to 00:15, ..... 10: 00 to 10: 15, 10: 15 to 10: 30 and so on to watch the activity during the day and when we have an activity pick.
this decomposition will be used in a single visualization
thanks in advance

 

2 Replies
Vegar
MVP
MVP

You could probably solve this by using  IntervalMatch between your time of day transactions and a quarter of day table.  

IntervalMatch ‒ Qlik Sense on Windows

marcus_sommer

You may just round your time, maybe something in this way:

time(floor(YourTime, 1/24/60*15), 'hhmm')

- Marcus