topic Re: am/pm hour format in App Development

am/pm hour format

Wed, 28 Jun 2017 09:00:44 GMT

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 — Wed, 28 Jun 2017 09:08:16 GMT

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

Chanty4u — Wed, 28 Jun 2017 09:09:30 GMT

is this?

Wed, 28 Jun 2017 09:13:03 GMT

Hi,

Thanks for your response.

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

Wed, 28 Jun 2017 09:14:22 GMT

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 — Wed, 28 Jun 2017 09:19:54 GMT

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 — Wed, 28 Jun 2017 09:20:30 GMT

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

Anonymous — Wed, 28 Jun 2017 09:23:42 GMT

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]