topic Time format in QlikView

Time format

qw_johan — Fri, 29 Apr 2011 18:02:51 GMT

Hi,

I ran into a strange time format in one of the files I am loading. I can't get Qlikview to recognize it.

0,000243056

I can get Excel to format it correctly. According to Excel "00:00:21".

Does anyone know how to format/convert it in Qlikview?

Thanks,
Johan

Time format

erichshiino — Fri, 29 Apr 2011 18:32:29 GMT

All dates and timestamps in QlikView and Excel are just numbers.

What you see is just a mask that format numbers into days, hours, etc.

1 unit = 1 day, 1 hour = 1 /24 , 1 second = 1 / 24/3600 and so on.

to apply the timestamp mask back again, use this:

timestamp( yourFieldHere,'hh:mm:ss'')

you can replace the field by anything else (e.g. an expression) to work with charts.

You can check the article about timestamp on the help to get more details.

Rgds,

Time format

hector — Fri, 29 Apr 2011 18:33:30 GMT

use time(Field) and it will return "00:00:21", if you have your timeformat variable with hh:mm:ss

Rgds

Ps. be carefull with the ',', because the decimal separator must be '.'

Time format

qw_johan — Fri, 29 Apr 2011 19:13:26 GMT

Thank you so much Hector! I'd kiss you if I could.
I have been pulling my hair out over this. I was using the time() function...but you pointed one thing out to me the
importance of the separator being '.' and not ','. In my file it is ...guess what...yup... ',' . I just used Replace()....and it worked.
Time(Replace(Field, ',', '.'), 'hh:mm:ss')

Thanks again