Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Session Duration

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?

Session.jpg

4 Replies
Anil_Babu_Samineni

May be try

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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