Qlik

[Chinnu3]

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. 

[abhijitnalekar]

Hi @Chinnu3 ,

Please try the below expression.

=Interval([Timestamp("Close Date")]-[timestamp("Open Date")],'DD HH:mm:ss')

and formatting you can get the 

https://community.qlik.com/t5/QlikView-App-Dev/Date-Square-Problem/m-p/1120826/highlight/true#M89540...

[Anku]

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'