Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

am/pm hour format

Hi,

I have this hour: 12:35:24. This is the question: How is it possible to create an hour format with adding AM or PM.

7 Replies
swuehl
MVP
MVP

Time( TimeField, 'hh:mm:ss TT')

On Format Codes for Numbers and Dates

Chanty4u
MVP
MVP

Hi

is this?

  1. time.PNG
Not applicable
Author

Hi,

Thanks for your response.

Is It possible to modify 24 h format in 12h format not inside the script?

Not applicable
Author

Hi Chanty,

The problem is in Qlik sense.

I don't want to modify the script, I want to modify the hour during the construction of my app

Chanty4u
MVP
MVP

try this in script

aa:

LOAD * Inline [

time

12:34:25

10:30:18

];

Result:

LOAD *,

Timestamp (time(time, 'hh:mm:ss '),'hh:mm:ss TT') as new

Resident aa; 

new.PNG

swuehl
MVP
MVP

Yes, by using same expression in a chart object as calculated dimension or expression.

Anonymous
Not applicable
Author

You can use this expression within the viz in your app:

   =Time('16:35:24' , 'hh:mm:ss TT')

Or in your viz's properties go to the Number Formatting and set it to :

  • Date
  • 3:30:40 pm   [This is Qlik giving the option as a sample of what the output will look like]