topic Re: Time conversation in QlikView

Time conversation

bhavvibudagam — Mon, 02 May 2016 08:49:43 GMT

Hi,

Can any one help me to do.

In An 'AHT' fleld i have multiple records like 0:05:03 , 0:04:59 so on.I have to convert this hh:mm:ss format to number.My required format is in AHT fIeld the records are like 303, 299.

Please answer this question in scripting with dynamic expression.

Thanks,

Re: Time conversation

sunny_talwar — Mon, 02 May 2016 08:53:41 GMT

Look here:

Re: Time Conversation

Re: Time conversation

marcus_sommer — Mon, 02 May 2016 08:54:32 GMT

You could use: = interval('00:05:03', 'ss')

- Marcus

Re: Time conversation

swuehl — Mon, 02 May 2016 08:58:32 GMT

Please avoid posting multiple times the same request.

Thanks.