Reserved word for converting seconds to time in QV?

[#1]

Does QV have a reserved word or a specific format to convert seconds into minutes?

Thank you!

Sarah

[johnw]

I don't think so. I would divide by 60. Unless I'm not understanding what you're asking.

[#3]

Thank you John, that's what I thought.

Sarah

[johnw]

Not that I would EVER do this, but I DID just think of a way to convert from seconds to minutes without ever "knowing" how many seconds are in a minute.

num(num#(text(interval(interval#(SecondsField,'ssssss'),'mmmmmm'))),'#,##0')

You tell QlikView to interpret your SecondsField as an interval in seconds (ssssss). Then you tell it you want to see that interval formatted as minutes (mmmmmm). Then you tell it to convert that to text, and finally to a number (if you went directly to a number, you'd get QlikView's internal representation of an interval, which isn't what we want here).

[rwunderlich · Accepted solution]

saraht wrote:Does QV have a reserved word or a specific format

If you wanted a Qlikview time value, then:

=timestamp#(seconds, 's')

To display the value a minutes:

=interval(timestamp#(seconds, 's'), 'm')

-Rob

[#6]

In the 'Number' tab be sure to set the 'Number Format Settings' to 'Interval' or the format will be incorrect.