topic Avg function throwing an error in QlikView https://community.qlik.com/t5/QlikView/Avg-function-throwing-an-error/m-p/522594#M1149306 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an expression like this which works correctly.</P><P></P><P>Interval(if(len(Max(END_DATE))=0,Today(),Max(END_DATE))-Min(START_DATE),'dd')</P><P></P><P>But When i tried to do an average of it, it says Error in Expression.</P><P>Avg(Interval(if(len(Max(END_DATE))=0,Today(),Max(END_DATE))-Min(START_DATE),'dd'))</P><P></P><P>Could anyone understand the mistake in this? START_DATE and END_DATE are timestamps.</P><P></P><P>Thanks</P><P>Ramakanth</P></BODY></HTML> Fri, 28 Jun 2013 19:36:48 GMT 2013-06-28T19:36:48Z Avg function throwing an error https://community.qlik.com/t5/QlikView/Avg-function-throwing-an-error/m-p/522594#M1149306 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an expression like this which works correctly.</P><P></P><P>Interval(if(len(Max(END_DATE))=0,Today(),Max(END_DATE))-Min(START_DATE),'dd')</P><P></P><P>But When i tried to do an average of it, it says Error in Expression.</P><P>Avg(Interval(if(len(Max(END_DATE))=0,Today(),Max(END_DATE))-Min(START_DATE),'dd'))</P><P></P><P>Could anyone understand the mistake in this? START_DATE and END_DATE are timestamps.</P><P></P><P>Thanks</P><P>Ramakanth</P></BODY></HTML> Fri, 28 Jun 2013 19:36:48 GMT https://community.qlik.com/t5/QlikView/Avg-function-throwing-an-error/m-p/522594#M1149306 2013-06-28T19:36:48Z Re: Avg function throwing an error https://community.qlik.com/t5/QlikView/Avg-function-throwing-an-error/m-p/522595#M1149307 <HTML><HEAD></HEAD><BODY><P>You are embedding max() aggregation function into another aggregation function, avg(), which is not possible without using advanced aggregation aggr() function.</P></BODY></HTML> Fri, 28 Jun 2013 20:03:50 GMT https://community.qlik.com/t5/QlikView/Avg-function-throwing-an-error/m-p/522595#M1149307 swuehl 2013-06-28T20:03:50Z