topic AVG Aggregation in QlikView https://community.qlik.com/t5/QlikView/AVG-Aggregation/m-p/195506#M55972 <HTML><HEAD></HEAD><BODY><P>When you use expression charts, you can calculat a total of sum rows!!!</P><P></P><P></P><H4>aggr ( [ distinct | nodistinct ] [{set_expression}] expression {, dimension} )</H4><P>Returns a set of values of expression calculated over dimensions. The result can be compared to the expression column of a 'local chart', evaluated in the context where the aggr function resides. Each dimension must be a single field. It cannot be an expression (calculated dimension).</P><P>If the expression argument is preceded by the nodistinct qualifier, each combination of dimension values may generate more than one return value, depending on underlying data structure. If the expression argument is preceded by the distinct qualifier or if no qualifier is used at all, each combination of dimension values will generate only one return value.</P><P>By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a <A>set</A> expression.</P><P>By using this function in <A>calculated dimensions</A> it is possible to achieve nested chart aggregation in multiple levels. See also <A>Nested aggregation and related issues</A>.</P><P>When used in chart expressions it is possible to achieve <A>sum-of-rows totals in a pivot table</A>.</P><H2>Examples:</H2><P>aggr( sum(Sales), Country )</P><P>aggr( nodistinct sum(Sales), Country )</P><P>aggr( sum(Sales), Country, Region )</P><P>count( aggr( sum(Sales), Country ))</P><BR /><BR /></BODY></HTML> Thu, 09 Sep 2010 18:08:10 GMT 2010-09-09T18:08:10Z AVG Aggregation https://community.qlik.com/t5/QlikView/AVG-Aggregation/m-p/195505#M55971 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P>What is the rule or the function of AVG agregation?</P><P>Thanks</P><P></P></BODY></HTML> Thu, 09 Sep 2010 17:21:00 GMT https://community.qlik.com/t5/QlikView/AVG-Aggregation/m-p/195505#M55971 2010-09-09T17:21:00Z AVG Aggregation https://community.qlik.com/t5/QlikView/AVG-Aggregation/m-p/195506#M55972 <HTML><HEAD></HEAD><BODY><P>When you use expression charts, you can calculat a total of sum rows!!!</P><P></P><P></P><H4>aggr ( [ distinct | nodistinct ] [{set_expression}] expression {, dimension} )</H4><P>Returns a set of values of expression calculated over dimensions. The result can be compared to the expression column of a 'local chart', evaluated in the context where the aggr function resides. Each dimension must be a single field. It cannot be an expression (calculated dimension).</P><P>If the expression argument is preceded by the nodistinct qualifier, each combination of dimension values may generate more than one return value, depending on underlying data structure. If the expression argument is preceded by the distinct qualifier or if no qualifier is used at all, each combination of dimension values will generate only one return value.</P><P>By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a <A>set</A> expression.</P><P>By using this function in <A>calculated dimensions</A> it is possible to achieve nested chart aggregation in multiple levels. See also <A>Nested aggregation and related issues</A>.</P><P>When used in chart expressions it is possible to achieve <A>sum-of-rows totals in a pivot table</A>.</P><H2>Examples:</H2><P>aggr( sum(Sales), Country )</P><P>aggr( nodistinct sum(Sales), Country )</P><P>aggr( sum(Sales), Country, Region )</P><P>count( aggr( sum(Sales), Country ))</P><BR /><BR /></BODY></HTML> Thu, 09 Sep 2010 18:08:10 GMT https://community.qlik.com/t5/QlikView/AVG-Aggregation/m-p/195506#M55972 2010-09-09T18:08:10Z