topic *** Need help with Aggr() Expression *** in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/309194#M499164 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><SPAN style="font-size: 12px; font-family: 'trebuchet ms', geneva;"><EM style="font-size: 12px; color: #800080;"><STRONG style="font-size: 12px;">SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId, ParentId))</STRONG></EM></SPAN></P><P><SPAN style="font-size: 12px; font-family: 'trebuchet ms', geneva;"><EM style="font-size: 12px; color: #800080;"><STRONG style="font-size: 12px;"><BR /></STRONG></EM></SPAN></P></BODY></HTML> Tue, 26 Jul 2011 18:01:09 GMT danielrozental 2011-07-26T18:01:09Z *** Need help with Aggr() Expression *** https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/309193#M499163 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;"><EM>Dear All,</EM></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM>I am stuck with an expression which works fine when I filter the data and it gives incorrect numbers when I dont filter the data. Here is the expression...</EM></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Dimension :</SPAN></P><P><SPAN style="color: #800080;"><EM><STRONG style="font-family: trebuchet ms,geneva;">ParentID</STRONG></EM></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Expression :</SPAN></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM style="color: #800080;"><STRONG>SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId))</STRONG></EM></SPAN></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM style="color: #800080;"><STRONG><BR /></STRONG></EM></SPAN></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM>This works fine, when I filter on the Field <SPAN style="color: #ff0000;"><STRONG>ParentID </STRONG></SPAN>(Which is my only dimension). However, if I dont filter on the </EM><EM style="color: #ff0000;"><STRONG>ParentID </STRONG><SPAN style="color: #000000;">it gives incorrect numbers. I am not sure where is the problem. Unfortunately I cant load the QV document because it contains sensitive information. Can someone please help...?</SPAN></EM></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM>Thanks a ton in advance.</EM></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM><STRONG>Cheers - DV</STRONG></EM></SPAN></P></BODY></HTML> Tue, 26 Jul 2011 17:54:35 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/309193#M499163 IAMDV 2011-07-26T17:54:35Z *** Need help with Aggr() Expression *** https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/309194#M499164 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><SPAN style="font-size: 12px; font-family: 'trebuchet ms', geneva;"><EM style="font-size: 12px; color: #800080;"><STRONG style="font-size: 12px;">SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId, ParentId))</STRONG></EM></SPAN></P><P><SPAN style="font-size: 12px; font-family: 'trebuchet ms', geneva;"><EM style="font-size: 12px; color: #800080;"><STRONG style="font-size: 12px;"><BR /></STRONG></EM></SPAN></P></BODY></HTML> Tue, 26 Jul 2011 18:01:09 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/309194#M499164 danielrozental 2011-07-26T18:01:09Z Re: *** Need help with Aggr() Expression *** https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/309195#M499165 <HTML><HEAD></HEAD><BODY><P><EM>Daniel – Thanks so much for quick response. This was a silly question... I went back last night and referred the documentation again and gotit working. </EM></P><P></P><P><EM>Cheers - DV</EM></P></BODY></HTML> Wed, 27 Jul 2011 08:48:31 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/309195#M499165 IAMDV 2011-07-27T08:48:31Z