Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ysj
Creator
Creator

want to create time bucket

How to create time bucket

Expected:

00.00-12.30 AM

12.30-01.00 AM

01.00-01.30 AM

01.30-02.00 AM

02.00-02.30 AM......

.

.

..

...

.

11.30PM- 12.00AM(00.00)


I have filed like

pic.JPG


8 Replies
Clever_Anjos
Employee
Employee

Try reading this Buckets, or just

Timestamp(Floor(yourfield, 1/48))

its_anandrjs

Use Class function for this

ysj
Creator
Creator
Author

please give some example

ysj
Creator
Creator
Author

not getting expected result

Clever_Anjos
Employee
Employee

could you post a sample of your data?

It really should work, I use this technique every day...

ysj
Creator
Creator
Author

its_anandrjs

Share some sample data.

MrJanjua
Contributor II
Contributor II

f2cffb26-d4f8-4fe9-b36c-18b49e901d2f.jpg

 Here is the time interval data can any give me express for this

 

Time

12:00

03:45

15:40

18:35

21:22

14:17

6:20