topic Time in QlikView

Time

evansabres — Tue, 01 Dec 2015 20:53:04 GMT

Hello -

In my application, I am trying to utilize a list box to display appointment times.

My data source displays the time in the following format: hh:mm:ss TT. (For example, 2:30:00 PM)

However, when I bring the data into my Qlik application, it displays in a 24 hour format (2:30 PM becomes 14:30)

How can I have this display as 2:30 PM in my application?

Thank you.

sunny_talwar — Tue, 01 Dec 2015 20:54:59 GMT

Check if your time format is set like this within QlikView:

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

And then may be this:

Time(TimeField) as TimeField,

evansabres — Tue, 01 Dec 2015 20:58:10 GMT

My Set TimeFormat is set up like that, however, still get the same results when I reload the ap.

My Field is Time' and the format it appears is HH:MM:SS AM/PM

Just want to make sure I explained this fully.

Thank you.

sunny_talwar — Tue, 01 Dec 2015 21:00:35 GMT

Try going into document properties (Alt +Ctrl + D) and set the TimeField format from there for the whole application and see if that helps.

evansabres — Tue, 01 Dec 2015 21:02:58 GMT

worked perfectly, thank you

sunny_talwar — Tue, 01 Dec 2015 21:06:52 GMT

Awesome