topic Re: How to convert "Session Duration" format in session log? in QlikView

How to convert "Session Duration" format in session log?

ysj — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Currenty I am using QlikView 12.10 server. In the Session log I observed that the Session Duration field give value as below

..i noticed that since QlikView 12 the "Session duration" format seems not to be the same....https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Server/Content/QlikView%20Server/QVSRM_Logging.htm?_ga=2.224110811.….

But I want format as below. Please help me out? ''

Re: How to convert "Session Duration" format in session log?

Anil_Babu_Samineni — Fri, 09 Jun 2017 02:14:26 GMT

Perhaps this?

Time(TimeStamp(SessionDuration))

Re: How to convert "Session Duration" format in session log?

ysj — Fri, 09 Jun 2017 02:48:59 GMT

Thank you Anil,

I have use your expression in list box.

But is it correct?

basically I dont know how to validate this if it is coorrect?

Re: How to convert "Session Duration" format in session log?

Anil_Babu_Samineni — Fri, 09 Jun 2017 02:59:31 GMT

When you use Time it shouldn't come period like AM and PM. Can you re check in script the same. I assume this is correct as per my knowledge because the time stamp you gave me 0.021921 is the number. Here, We have to calculate manually for that like from number to Hour and Minutes and Seconds then we have to look whether our function is working or not.