Wrong format for Session Duration in Qlikview's Session Log files

The help site states that the Session Duration in the Session log files is in hours:minutes:seconds

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Server/Content/QlikView-Server/QVSRM_Logging.htm 

However, since QlikView 12, that field has become "human unreadable".

Environment:

QlikView 12
QlikView 12.10
QlikView 12.20 (November 2017)

 

This behaviour has been identified as a bug, with ID QV-14349. A fix is currently being worked on, with a release targeted for Qlik Sense 12.30 (November 2018).

As a workaround, the session duration can be calculated by either:

• comparing the values from the "Session Start" and the "Timestamp" columns and manually subtracting them
• calculating it from the "Session Duration" column. This field currently indicates the duration in "double days". Multiply that value by 86400 to get the duration in seconds.

  If the value is `0.020972`, that can be calculated like this:
  0.020972 * 24 * 60 * 60 sec = 1811.9808 sec = 30.19968 min = 00:30:11.9808 (30min 12sec)

Information provided on this defect is given as is at the time of documenting.  For up to date information, please review the most recent Release Notes, or contact support at support.qlik.com with the ID (QV-14349) for reference.