Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two dates along with time
Closed date (2020-11-16 09:30:45)
Open date (2020-11-14 06:35:40)
(Closed date - Open date)
I want mean time in (days and hr:mm:ss) format like 2days 2hrs 54mins 56 seconds
In Qlik sense measure in Qlik table.
Hi @Chinnu3 ,
Please try the below expression.
=Interval([Timestamp("Close Date")]-[timestamp("Open Date")],'DD HH:mm:ss')
and formatting you can get the
Hi @Chinnu3 ,
To get the difference as a statement,
Try below:
1. Create a variable
Name: vDifference
Definition: Date([Closed date] - [Open date],'HH:MM:SS')
2. Create table
Dimension: Open date
Dimension: Closed date
Measure:
Interval(timestamp([Closed date])- timestamp([Open date]),'DD')&' Day '& Hour($(vDifference))&' Hrs '& Minute($(vDifference))&' min '& Second($(vDifference))&' sec'