Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Omkar13
Contributor III
Contributor III

How to calculate the time difference between two timestamp?

How do I calculate time difference between two time stamps for a status?

I want to calculate the time between when an item was in Open and item got closed.

FromStatus Created.Cal.timestamp Y-M-D h:m CategorieStatusFrom ToStatus CategorieStatusTo
Open 22/6/2020 4:35:02 PM To Do In Progress In Progress
In Progress 22/4/2021 3:59:39 PM In Progress Done Done

 

PFA dummy data for reference.

 

Thanks in advance.

Labels (2)
1 Reply
NitinK7
Specialist
Specialist

please check INTERVAL function