Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
merrillbrink
Contributor II
Contributor II

Issue converting time measurement

Hi all,

I’m having an issue converting a time measurement into seconds, hours etc.

The field total_time appears to load in a string format, e.g. 00162597 corresponds to 00 hours:16 minutes:25 seconds.97milliseconds.

I have tried the following expression =Interval(Time#(total_time,'hh:mm:ss.ff'),'ss') to convert it to seconds, but it’s returning a null value.

What’s I find strange is that if I enter =Interval(Time#(00:16:25.77,'hh:mm:ss.ff'),'ss') it will return the correct value, 985.97 seconds.

Is there an issue with how it’s reading the field? Should I have it time-stamped in the load string in a certain way initially?

Thanks for any help.

2 Replies
sunny_talwar

Try this may be:

=Interval(Time#(total_time,'hhmmssff'), 'ss')

sunny_talwar

Or this

=Interval(Time#(00162597,'hhmmssff'), 'ss.ff')

Capture.PNG