topic MakeTime from web data Date in QlikView

MakeTime from web data Date

Fri, 01 Mar 2013 12:34:11 GMT

Hi All,

I have loaded some data from a web page.

This data contains a time (mm:ss.hs), but some of it shows as txt and some as a date.

I have tried MakeTime, by 1st seperating the Mins/Secs/ and Hundreths into new fields.

Time(Field,'mm:ss.ff') this does not work either.

Please can someone come up with a solution for me as I need to use this data in a line chart, and in its current format it does not work.

Thank you

kaushiknsolanki — Fri, 01 Mar 2013 12:37:45 GMT

Try this,

time(time#(TimeField,'hh:mm:ss')) as New_Time

Regards,

Kaushik Solanki

Fri, 01 Mar 2013 13:25:00 GMT

Thank you Kaushik,

Worked a treat!!!