topic Aggr Performance in QlikView

topic Aggr Performance in QlikView https://community.qlik.com/t5/QlikView/Aggr-Performance/m-p/453572#M570816 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to know if the order of dimensions in AGGR function can influence the performance.</P><P></P><P>Eg. Fields:</P><P> X >>> 50.000.000 or rows</P><P>Y >>> 10 rows</P><P>Z >>> 500 rows</P><P></P><P>1. Agg(sum(Qty), X,Y,Z)</P><P>2. Agg(sum(Qty), Y,Z,X)</P><P></P><P>What is the best AGGR, 1 or 2?</P><P></P><P>Regards</P><P>Luca Jonathan Panetta</P><P><A href="http://www.pljsoftware.com">PLJ Software</A></P></BODY></HTML> Fri, 28 Sep 2012 15:43:19 GMT pljsoftware 2012-09-28T15:43:19Z Aggr Performance https://community.qlik.com/t5/QlikView/Aggr-Performance/m-p/453572#M570816 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to know if the order of dimensions in AGGR function can influence the performance.</P><P></P><P>Eg. Fields:</P><P> X >>> 50.000.000 or rows</P><P>Y >>> 10 rows</P><P>Z >>> 500 rows</P><P></P><P>1. Agg(sum(Qty), X,Y,Z)</P><P>2. Agg(sum(Qty), Y,Z,X)</P><P></P><P>What is the best AGGR, 1 or 2?</P><P></P><P>Regards</P><P>Luca Jonathan Panetta</P><P><A href="http://www.pljsoftware.com">PLJ Software</A></P></BODY></HTML> Fri, 28 Sep 2012 15:43:19 GMT https://community.qlik.com/t5/QlikView/Aggr-Performance/m-p/453572#M570816 pljsoftware 2012-09-28T15:43:19Z