Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

10 min time interval

I have the check in time data (ex: 20:02:30) and I'm trying to group them into 15 min intervals to analyze their evolution along the day. Don't know how to fix it.... help will be very appreciated.

Thanks

11 Replies
Not applicable
Author

Numbers like:

0,013888888888889

0,027777777777778

0,034722222222222

0,34722222222222

...

m_woolf
Master II
Master II

You need to format that field as you wish. Something like:

Timestamp(floor(frac([Hora])*144)/144+floor([Hora]),'M/D/YY hh:mm TT') as YourNewFieldName,