Re: Time Buckets from Timestamp - Qlik Community

WernerDC · ‎2021-08-26

Good day Qlickers.

As you know, Dates are a headache in Qlik Sense. I always have a hard time around them.

How do I get a timestamp to hourly buckets?

Ive tried some stuff already but I cant seem to get it to work.

See the table attached:

I want to create Hourly buckets on that Timestamp if possible. My times are in 24hours.

This is my script:

Hope someone can help me.

Kind regards

Clever_Anjos · ‎2021-08-26

Use Trunc(yourdatetimefield,1/24) to convert to lowest hour

Clever_Anjos · ‎2021-08-26

In meantime "Dates are NOT a headache in Qlik Sense." 🙂 🙂

WernerDC · ‎2021-08-27

This trunc is not recognized in my script?

WernerDC · ‎2021-08-27

Hi,

I tried this and it works if I do a limited load thru the debugger. It returns exactly what I want.

Input:

Output: See Time and Bucket columns. It works.

Problem is, when I reload the entire App, the Time and Bucket Fields return Blank. What causes this?

Hope you can help me

Kind regards

Clever_Anjos · ‎2021-08-27

I´m so sorry, my mistake

Use Floor(yourdatetimefield,1/24) to convert to the lowest hour