topic Re: Time Buckets from Timestamp in App Development

Time Buckets from Timestamp

WernerDC — Thu, 26 Aug 2021 20:22:12 GMT

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 — Thu, 26 Aug 2021 20:37:49 GMT

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

Clever_Anjos — Thu, 26 Aug 2021 21:04:28 GMT

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

WernerDC — Fri, 27 Aug 2021 06:52:19 GMT

This trunc is not recognized in my script?

WernerDC — Fri, 27 Aug 2021 07:40:05 GMT

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 — Fri, 27 Aug 2021 12:05:58 GMT

I´m so sorry, my mistake

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