Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Format Timestamp by Hour

I would like to show data by hour 12am - 12pm.  The expression below works, but I would like to display the PM time as 1pm, 2pm, 3pm, etc. instead of 13pm, 14pm, 15pm, etc.

Any suggestions on how to update to adjust the timestamp for the PM hours? 

Timestamp([Interaction Start Date Time UTC], 'h') & Timestamp([Interaction Start Date Time UTC],'TT')

Tags (1)
1 Solution

Accepted Solutions

Re: Format Timestamp by Hour

Or even this:

Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')

2 Replies

Re: Format Timestamp by Hour

How about this:

Timestamp([Interaction Start Date Time UTC], 'h TT')

or

Timestamp(Floor([Interaction Start Date Time UTC], 1/24), 'h TT')

Re: Format Timestamp by Hour

Or even this:

Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')

Community Browser