Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You may just round your time, maybe something in this way:
time(floor(YourTime, 1/24/60*15), 'hhmm')
- Marcus