topic Timestamp Format Conversation in QlikView

Timestamp Format Conversation

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have Timestamp field like below table, how can i change into15 min interval format?

please consider minimum 15 minutes (ex. 01:28:00 ---> 01:15:00)

sunny_talwar — Tue, 19 Dec 2017 17:47:25 GMT

May be this

TimeStamp(Floor(TimeStamp, (1/4*24))) as Result

sunny_talwar — Tue, 19 Dec 2017 17:49:40 GMT

I think the calculation of floor is throwing it off, try this

Table:

LOAD *,

TimeStamp(Floor(Timestamp, 1/96)) as Result;

LOAD * INLINE [

Timestamp

11/20/2017 00:04:00

11/20/2017 01:00:00

11/20/2017 01:03:00

11/20/2017 01:05:12

11/20/2017 01:17:00

11/20/2017 02:12:15

11/20/2017 03:42:10

11/20/2017 03:19:42

11/20/2017 10:17:12

11/20/2017 11:17:15

11/20/2017 12:54:10

];

maxgro — Tue, 19 Dec 2017 17:51:04 GMT

Timestamp Fields in red

LOAD

Timestamp,

Timestamp(Floor(Timestamp#(Timestamp, 'MM/DD/YYYY hh:mm:ss'), 1/(24*4))) as Result

FROM

(html, codepage is 1252, embedded labels, table is @1);