topic Re: Time format. in QlikView

Time format.

Wed, 16 Apr 2014 04:14:31 GMT

Hi folks,

Can anyone advise me on how could I convert the time dimension from 24-hour to 12-hour format?

Sample script:

Time_DIM:

Load

time(frac(time_column),'HH12:MM:SS AM/PM');

@or

time(frac(time_column),'HH12:MM:SS');

From Time_DIM.xls;

Thanks.

Best Regards,

Re: Time format.

brijesh1991 — Wed, 16 Apr 2014 04:26:38 GMT

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

Re: Time format.

arjunkrishnan — Wed, 16 Apr 2014 04:48:00 GMT

Hai Asok Try This One

SET TimeFormat='h:mm:ss TT';

time(frac(time_column),'$(TimeFormat)');

'h:mm:ss'--->24 hrs Format

h:mm:ss TT-->12 hrs Format->Time Value In--->AM/PM

Re: Time format.

jagan — Wed, 16 Apr 2014 05:23:18 GMT

Hi,

Try like this

=Time(time_column, 'hh:mm:ss TT')

Regards,

Jagan.

Re: Time format.

er_mohit — Wed, 16 Apr 2014 05:31:44 GMT

simply use it on script side

timestamp(time_coloumn,'hh:mm:ss TT') as Time

Re: Time format.

amit_saini — Wed, 16 Apr 2014 05:50:50 GMT

Hi Ram,

Try this:

=Time(Your_Time_filed, 'hh:mm:ss TT')

Thanks,
AS

Re: Time format.

Wed, 16 Apr 2014 06:14:12 GMT

Hi guys,

The formats you guys stated worked, but am not getting the correct output. Have a look at the screenshot below:

Am only getting all the hours with 12 minutes in between, its not a full 24hours cycle with 1second intervals as expected. Please advise.

Thanks.

Best Regards,

Re: Time format.

Wed, 16 Apr 2014 06:22:43 GMT

Hi guys,

Its alright, found a out solution to it. Thanks!

Best Regards,