topic Re: Average Date Difference in QlikView https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352480#M572957 <HTML><HEAD></HEAD><BODY><P>Thanks a lot..</P></BODY></HTML> Mon, 16 Jul 2012 15:18:49 GMT ajithsachin 2012-07-16T15:18:49Z Average Date Difference https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352478#M572955 <HTML><HEAD></HEAD><BODY><P>hi..</P><P>i have a table like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD class="xl63" style="background-color: #3392cc;" width="64">code</TD><TD class="xl63" style="border-left-style: none; background-color: #3392cc;" width="64">date</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">01</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/04/12</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">01</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">08/04/12</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">01</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/04/12</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">02</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">01/04/12</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">03</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">02/04/12</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">04</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/04/12</TD></TR></TBODY></TABLE><P></P><P>i need the average date difference of each code</P><P>can anybody please help..</P></BODY></HTML> Mon, 16 Jul 2012 14:41:50 GMT https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352478#M572955 ajithsachin 2012-07-16T14:41:50Z Re: Average Date Difference https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352479#M572956 <HTML><HEAD></HEAD><BODY><P>avg(aggr(max(date)-min(date),code))</P><P></P><P>should do.</P><P></P><P>Kiran Rokkam.</P></BODY></HTML> Mon, 16 Jul 2012 15:15:05 GMT https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352479#M572956 2012-07-16T15:15:05Z Re: Average Date Difference https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352480#M572957 <HTML><HEAD></HEAD><BODY><P>Thanks a lot..</P></BODY></HTML> Mon, 16 Jul 2012 15:18:49 GMT https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352480#M572957 ajithsachin 2012-07-16T15:18:49Z Re: Average Date Difference https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352481#M572958 <HTML><HEAD></HEAD><BODY><P>Mark the discussion to closure.</P><P></P><P>Kiran.</P></BODY></HTML> Mon, 16 Jul 2012 15:42:26 GMT https://community.qlik.com/t5/QlikView/Average-Date-Difference/m-p/352481#M572958 2012-07-16T15:42:26Z