topic Re: Session Duration in QlikView

Session Duration

Anonymous — Fri, 20 Jan 2017 16:11:17 GMT

Hi,.

In qlikview 12, the session.log change format Session Duration... before was HH:MM:SS and now come someting like this:]

0.000087

0.000313

Anyone know who parse this number to format HH:MM:SS?

Anil_Babu_Samineni — Fri, 20 Jan 2017 16:16:52 GMT

May be try

Date(Timestamp([Session Duration]),'HH:MM:SS')

Anonymous — Fri, 20 Jan 2017 16:22:18 GMT

I try this before, but Timestamp not work...=/

But thanks anyway...

Anil_Babu_Samineni — Fri, 20 Jan 2017 16:32:41 GMT

Can you send the Data? Not the image then i will try

rwunderlich — Fri, 20 Jan 2017 17:45:05 GMT

It's already a QV time value -- fraction of a day. If you want to display it as hh:mm:ss use:

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

-Rob