topic Re: converting time in QlikView

converting time

Mon, 31 Aug 2015 07:41:18 GMT

Hello All,

Could you please help me convert 0530 into '05:30:00' in the load script.

Many Thanks,

Hasvine

sunny_talwar — Mon, 31 Aug 2015 07:43:14 GMT

Try this:

Time(Time#(TimeField, 'hhmm'), 'hh:mm:ss') as TimeField

Mon, 31 Aug 2015 07:55:02 GMT

Thank you.

Working great.

KR,

Hasvine

sunny_talwar — Mon, 31 Aug 2015 07:56:38 GMT

Great

I am glad it works.

Best,

Sunny

maxgro — Mon, 31 Aug 2015 07:58:16 GMT

you need the interpretation function Time# to convert the input value to a number

Time#('0530', 'hhmm')

then if you want a different format from the format you have at the beginning of your QlikView (.qvw), mine is

SET TimeFormat='hh:mm:ss';

you need the formatting function Time

Time(Time#('0530', 'hhmm'), 'hh:mm:ss')

replace 0530 with your field

and if you want more detail