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.
Time( TimeField, 'hh:mm:ss TT')
On Format Codes for Numbers and Dates
Thanks for your response.
Is It possible to modify 24 h format in 12h format not inside the script?
Yes, by using same expression in a chart object as calculated dimension or expression.
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
try this in script
LOAD * Inline [
Timestamp (time(time, 'hh:mm:ss '),'hh:mm:ss TT') as new
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 :
Retrieving data ...