topic aggr? in QlikView https://community.qlik.com/t5/QlikView/aggr/m-p/690189#M1079150 <HTML><HEAD></HEAD><BODY><P>aggr(Avg(Total &lt;Batch&gt; Value), Batch)</P><P></P><P></P><P></P><P>how it caluclate?</P></BODY></HTML> Wed, 16 Jul 2014 17:17:42 GMT 2014-07-16T17:17:42Z aggr? https://community.qlik.com/t5/QlikView/aggr/m-p/690189#M1079150 <HTML><HEAD></HEAD><BODY><P>aggr(Avg(Total &lt;Batch&gt; Value), Batch)</P><P></P><P></P><P></P><P>how it caluclate?</P></BODY></HTML> Wed, 16 Jul 2014 17:17:42 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/690189#M1079150 2014-07-16T17:17:42Z Re: aggr? https://community.qlik.com/t5/QlikView/aggr/m-p/690190#M1079151 <HTML><HEAD></HEAD><BODY><P>the aggr function makes a list.</P><P></P><P>So in your example you might have Batches: A, B, C, D, E....</P><P>Each of your Batches will have numerous values associated with them..</P><P></P><P>So your aggr function creates a list of average values based on Batch. For example:</P><P></P><P>avg(values associated with A)</P><P>avg(values associated with B)</P><P>avg(values associated with C)</P><P>avg(values associated with D)</P><P>avg(values associated with E)</P></BODY></HTML> Wed, 16 Jul 2014 18:03:34 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/690190#M1079151 2014-07-16T18:03:34Z