Wrong format for Session Duration in Qlikview's Session Log filesArticle Number: 000055500 | Last Modified: 2018/08/28
The help site states that the Session Duration in the Session log files is in hours:minutes:seconds
|Session Duration||Duration of session in hours:minutes:seconds.|
However, since QlikView 12, that field has become "human unreadable".
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.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.