topic Re: Average of Difference between two Timestamp fields in QlikView https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134770#M757087 <HTML><HEAD></HEAD><BODY><P>No. Still a blank value <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plain.png" /></P></BODY></HTML> Mon, 17 Sep 2018 20:10:08 GMT qlikwiz123 2018-09-17T20:10:08Z Average of Difference between two Timestamp fields https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134768#M757084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P></P><P><STRONG>Interval(Avg(Max([Date1])-Max(Date2),'hh:mm:ss'))</STRONG></P><P></P><P>But <STRONG>Interval(Max([Date1])-Max(Date2),'hh:mm:ss') </STRONG>gives a value in the text box.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134768#M757084 qlikwiz123 2020-11-25T16:16:04Z Re: Average of Difference between two Timestamp fields https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134769#M757085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>And if you try with :</P><P></P><P>=interval(avg(TOTAL Interval(Max([Date1]) - Max([Date2]),'hh:mm:ss')))</P></BODY></HTML> Mon, 17 Sep 2018 19:46:56 GMT https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134769#M757085 sergio0592 2018-09-17T19:46:56Z Re: Average of Difference between two Timestamp fields https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134770#M757087 <HTML><HEAD></HEAD><BODY><P>No. Still a blank value <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plain.png" /></P></BODY></HTML> Mon, 17 Sep 2018 20:10:08 GMT https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134770#M757087 qlikwiz123 2018-09-17T20:10:08Z Re: Average of Difference between two Timestamp fields https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134771#M757088 <HTML><HEAD></HEAD><BODY><P>what result do you expect this nested aggregation to deliver, based on which data. Can you post an example?</P></BODY></HTML> Mon, 17 Sep 2018 21:13:48 GMT https://community.qlik.com/t5/QlikView/Average-of-Difference-between-two-Timestamp-fields/m-p/134771#M757088 MarcoWedel 2018-09-17T21:13:48Z