topic Session duration in QV V12 in QlikView

Session duration in QV V12

reijk317 — Sat, 16 Nov 2024 20:34:15 GMT

Hello,

I have a problem with session duration and the solutions here in this forum doesn't work for my.

It will work if I put a time in the expression, but not when I use the fieldname.

interval(0.002963,'hh:mm:ss')

interval([Session duration],'hh:mm:ss')

Re: Session duration in QV V12

marcus_sommer — Thu, 27 Jun 2019 12:17:42 GMT

Your field won't be interpreted as a numeric value and therefore the formatting failed. This means you need to convert this field with the default-variables of your application (be careful - it's a global setting) or with a function like num#() or maybe just with some replace like: replace([Session Duration], chr(46), ','). It depends on your data and your requirements which way is the most suitable.

- Marcus