topic Re: Time format issue in QlikView

Time format issue

vanderson009 — Wed, 25 Nov 2020 16:16:04 GMT

On bar chart I have Time Field on Y axis, and its shown as like

12:01:30 AM

12:00:30 AM

12:00:00 AM

but I want to convert AM into 24 hr but I could not able to do it.

Can some please help me to convert it into 24 hr time format.

Thanks,

Villyee

Re: Time format issue

jonathandienst — Tue, 26 Apr 2016 07:44:46 GMT

Time(Time#('12:01:30 AM', 'hh:mm:ss tt'), 'hh:mm:ss')

Or to use with [Time] field:

Time(Time#([Time], 'hh:mm:ss tt'), 'hh:mm:ss')

Re: Time format issue

jonathandienst — Tue, 26 Apr 2016 07:47:27 GMT

If Time is already a proper QV time field and you just want to format it to 24hr, you don't need the Time#() part:

Time([Time], 'hh:mm:ss')

Re: Time format issue

arulsettu — Tue, 26 Apr 2016 07:48:10 GMT

may be this

Timestamp(Timestamp#('12:01:30 AM','hh:mm:ss TT'),'hh:mm:ss')

Re: Time format issue

vanderson009 — Tue, 26 Apr 2016 07:58:01 GMT

Hi Jonathan,

Thanks for you reply, In database that values in number format, how can I handle it then.

Regards,

Villyee

Re: Time format issue

MindaugasBacius — Tue, 26 Apr 2016 08:14:40 GMT

If the Time is loaded as the digit than try this formula:

Time(Time, 'hh:mm:ss').

Re: Time format issue

sunny_talwar — Tue, 26 Apr 2016 09:17:30 GMT

Can you show few datapoints just to make sure we understand how time looks? Is it in decimals like 0.2465214 or is it an integer?

Re: Time format issue

Kushal_Chawda — Tue, 26 Apr 2016 09:23:41 GMT

if it is in number then what that number represents? is it days ? is it hour ? is it seconds?

Re: Time format issue

vanderson009 — Tue, 26 Apr 2016 09:25:58 GMT

When I am doing it in straight table, then getting 24 hr time format, however straight table convert into bar chart then y-axis showing 12 hr format.

Re: Time format issue

vanderson009 — Tue, 26 Apr 2016 09:42:05 GMT

Hi Sunny,

Is it in decimal..

Re: Time format issue

tresB — Tue, 26 Apr 2016 09:53:03 GMT

Simple formatting should work then. Try like:

Time([TimeField], 'hh:mm:ss')

Re: Time format issue

swuehl — Tue, 26 Apr 2016 09:54:37 GMT

You can also set an explicite format on number tab, select time and format 'hh:mm:ss'.