Session Duration

[Anonymous]

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]

May be try

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

[Anonymous]

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

But thanks anyway...

[Anil_Babu_Samineni]

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

[rwunderlich]

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

http://masterssummit.com

http://qlikviewcookbook.com