topic *** Need help with Aggr() Expression *** in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/308859#M114025 <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></EM><EM>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...?</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:52:28 GMT IAMDV 2011-07-26T17:52:28Z *** Need help with Aggr() Expression *** https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/308859#M114025 <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></EM><EM>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...?</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:52:28 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Aggr-Expression/m-p/308859#M114025 IAMDV 2011-07-26T17:52:28Z