Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Champion III
Champion III

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
Champion III
Champion III

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