topic Re: Time Formatting in QlikView

Time Formatting

manisha_uit — Tue, 17 Jun 2014 12:57:31 GMT

Hi All,

I have a field ActualTime which is in "hh:mm:ss TT" format. In the script, I am changing it to "hh:mm TT" format using

Time(field, 'hh:mm TT')

Now, I am trying to plot ActualTime required to finish the task. The problem is i am unable to format the Y-axis in "hh:mm TT" format. However, when I hover over my mouse, i get the correct format "hh:mm TT"

Please refer image for more details

Thanks,

Manisha

Re: Time Formatting

giakoum — Tue, 17 Jun 2014 13:02:03 GMT

Time is a formatting function. It does not change the feild type. Try using Time# instead

Re: Time Formatting

jonathandienst — Tue, 17 Jun 2014 13:02:55 GMT

Go to Document Properties | Number, and set the time format for the field here.

HTH

Jonathan

Re: Time Formatting

manisha_uit — Wed, 18 Jun 2014 11:40:02 GMT

Hi Jonathan, loannis

I tried both the options suggested by you but the result is not as expected

Thanks,

Manisha

Re: Time Formatting

manisha_uit — Wed, 18 Jun 2014 12:02:25 GMT

Got the solution finally. I changed the TimeFormat variable to the desired format and it worked!