Average of Difference between two Timestamp fields

[qlikwiz123]

Hi,

How do I get the Average value of difference between two TimeStamp fields? I am using the below expression but it gives an empty value.

Interval(Avg(Max([Date1])-Max(Date2),'hh:mm:ss'))

But Interval(Max([Date1])-Max(Date2),'hh:mm:ss') gives a value in the text box.

[sergio0592]

Hi,

And if you try with :

=interval(avg(TOTAL Interval(Max([Date1]) - Max([Date2]),'hh:mm:ss')))

[qlikwiz123]

No. Still a blank value

[MarcoWedel]

what result do you expect this nested aggregation to deliver, based on which data. Can you post an example?