topic Re: When do I use the Aggr() function in an expressin, when in dimension and when as calculated dimension and when as dynamic? in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822933#M2936 <HTML><HEAD></HEAD><BODY><P>Well I readed the documents but I still don t understand it the proper way when to use a calculated dim, dynamic dim or expression. May be you have some simple examples.</P></BODY></HTML> Thu, 13 Nov 2014 12:51:11 GMT 2014-11-13T12:51:11Z When do I use the Aggr() function in an expressin, when in dimension and when as calculated dimension and when as dynamic? https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822931#M2934 <HTML><HEAD></HEAD><BODY><P>Would be great if someone can explain when to use the function and wherere and how to use it.</P></BODY></HTML> Wed, 12 Nov 2014 21:51:53 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822931#M2934 2014-11-12T21:51:53Z Re: When do I use the Aggr() function in an expressin, when in dimension and when as calculated dimension and when as dynamic? https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822932#M2935 <HTML><HEAD></HEAD><BODY><P>The Aggr creates an array of aggregations, which you can use for nested aggregations or for dynamic dimensions.</P><P></P><P>See more on</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/07/aggr">Aggr...</A></P><P><A href="https://community.qlik.com/docs/DOC-3857">QlikView Technical Brief - AGGR.docx</A></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/11/when-should-the-aggr-function-not-be-used">When should the Aggr() function NOT be used?</A></P><P></P><P>HIC</P></BODY></HTML> Thu, 13 Nov 2014 09:11:53 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822932#M2935 hic 2014-11-13T09:11:53Z Re: When do I use the Aggr() function in an expressin, when in dimension and when as calculated dimension and when as dynamic? https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822933#M2936 <HTML><HEAD></HEAD><BODY><P>Well I readed the documents but I still don t understand it the proper way when to use a calculated dim, dynamic dim or expression. May be you have some simple examples.</P></BODY></HTML> Thu, 13 Nov 2014 12:51:11 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822933#M2936 2014-11-13T12:51:11Z Re: When do I use the Aggr() function in an expressin, when in dimension and when as calculated dimension and when as dynamic? https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822934#M2937 <HTML><HEAD></HEAD><BODY><P>when u want find the sales for row wise</P><P>aggr is like adding the multiple dimension</P><P>ex:</P><P>aggr(sum(sales),id,product))</P><P></P><P>or</P><P>aggr(sum(sales)product)</P></BODY></HTML> Thu, 13 Nov 2014 13:06:19 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/When-do-I-use-the-Aggr-function-in-an-expressin-when-in/m-p/822934#M2937 2014-11-13T13:06:19Z