am/pm hour format

[#1]

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.

[swuehl]

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

On Format Codes for Numbers and Dates

[Chanty4u]

Hi

is this?

1. 

[#4]

Hi,

Thanks for your response.

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

[#5]

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]

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; 

[swuehl]

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

[Anonymous]

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]