Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarkharpude
Creator III
Creator III

Session duration in QlikSense

Hi All,

Greetings for the Day!

Could you please tell me how to calculate session duration in Qlik Sense. I am checking Sessions log file. It's having Session Duration as a field and it's giving value something like this. 3.939074. I want to show it in hrs:mm:ss format.  

Thanks,

Sagar

 

 

Labels (1)
1 Reply
xsteijns
Contributor
Contributor

Hi Sagar,

Saw this unanswered post when looking for something else. The data is available in the operations monitor as [Session Duration] the value is in days. You can divide the value by 1440 to get the minutes. a value specific for a month can be like
interval(Sum({<Month={"Jul 2022"}>}[Session Duration])/1440,'DD hh:mm:ss')