topic Aggr Function in QlikView https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/938578#M956418 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have one doubt on Aggr() function....</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">* Aggr() creates a temp table within the datamodel. </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">* Aggr() we can use both dimensions and metrics.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">* Aggr() function occupies more memory.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Right????<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">My Question..</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">How do we know Temp table created in memory???</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Thanks in Advance.....<BR /></SPAN></P></BODY></HTML> Thu, 05 Nov 2015 06:03:04 GMT paulwalker 2015-11-05T06:03:04Z Aggr Function https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/938578#M956418 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have one doubt on Aggr() function....</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">* Aggr() creates a temp table within the datamodel. </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">* Aggr() we can use both dimensions and metrics.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">* Aggr() function occupies more memory.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Right????<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">My Question..</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">How do we know Temp table created in memory???</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Thanks in Advance.....<BR /></SPAN></P></BODY></HTML> Thu, 05 Nov 2015 06:03:04 GMT https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/938578#M956418 paulwalker 2015-11-05T06:03:04Z Re: Aggr Function https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/938579#M956420 <HTML><HEAD></HEAD><BODY><P>Go thorough the following thread and attachment, you will get the idea about aggr():</P><P></P><P><A href="https://community.qlik.com/thread/38796">Aggr() function</A></P></BODY></HTML> Thu, 05 Nov 2015 06:09:02 GMT https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/938579#M956420 Anonymous 2015-11-05T06:09:02Z