topic How to calculate the average date? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-the-average-date/m-p/186488#M50556 <HTML><HEAD></HEAD><BODY><P>Hello Isaac,</P><P>In a pivot table, add Region as Dimension and in Expressions</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Avg(EndDate - StartDate)</PRE></BLOCKQUOTE><BR /><BR /> <P>Is that what you are looking for?</P></BODY></HTML> Tue, 29 Mar 2011 10:00:45 GMT Miguel_Angel_Baeyens 2011-03-29T10:00:45Z How to calculate the average date? https://community.qlik.com/t5/QlikView/How-to-calculate-the-average-date/m-p/186487#M50555 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have the following table:</P><P>load * Inline<BR />[<BR />StartDate, EndDate,Id, Region<BR />2010/01/01,2010/03/05,1, Brazil<BR />2010/03/01,2010/03/05,2, Brazil<BR />2010/03/01,2010/03/05,4, France<BR />]</P><P>I want to use pivot table to show the average active days(StartDate-EndDate) based on Region:</P><P>It looks like this:</P><P>Region days</P><P>Brazil 35</P><P>France 4</P><P>How to calculate that "days'?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 29 Mar 2011 09:54:27 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-average-date/m-p/186487#M50555 2011-03-29T09:54:27Z How to calculate the average date? https://community.qlik.com/t5/QlikView/How-to-calculate-the-average-date/m-p/186488#M50556 <HTML><HEAD></HEAD><BODY><P>Hello Isaac,</P><P>In a pivot table, add Region as Dimension and in Expressions</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Avg(EndDate - StartDate)</PRE></BLOCKQUOTE><BR /><BR /> <P>Is that what you are looking for?</P></BODY></HTML> Tue, 29 Mar 2011 10:00:45 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-average-date/m-p/186488#M50556 Miguel_Angel_Baeyens 2011-03-29T10:00:45Z How to calculate the average date? https://community.qlik.com/t5/QlikView/How-to-calculate-the-average-date/m-p/186489#M50557 <HTML><HEAD></HEAD><BODY><P>In a pivot table, you might want to use an AGGR:</P><P><STRONG>Avg(Aggr(EndDate-StartDate, Id))</STRONG></P><P></P><P>Regards,</P><P></P><P></P><P>Stephen</P><P></P></BODY></HTML> Tue, 29 Mar 2011 10:08:26 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-average-date/m-p/186489#M50557 stephencredmond 2011-03-29T10:08:26Z