topic Re: Problem with aggregate function in QlikView https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202790#M1251591 <HTML><HEAD></HEAD><BODY><P>Try this expression. You overally complicated your expression before</P><P></P><P><STRONG>=Sum(Total {&lt;Item&gt;} GP)/Sum(Total {&lt;Item&gt;} Sales) * Sum(Sales)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139687_Capture.PNG" style="height: 154px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Wed, 05 Oct 2016 12:29:28 GMT sunny_talwar 2016-10-05T12:29:28Z Problem with aggregate function https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202787#M1251587 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have a problem with AGGREGATE function. I am getting the GP value wrong when an item is selected. For example when an item <STRONG>a</STRONG> is selected the GP value should be 2571.429 but it is showing 9000.</P><P></P><P>Please find the attached QVW for your information.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202787#M1251587 pkpandey 2026-01-26T18:19:17Z Re: Problem with aggregate function https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202788#M1251588 <HTML><HEAD></HEAD><BODY><P>What is the logic behind getting 2571.429 here?</P></BODY></HTML> Wed, 05 Oct 2016 12:20:49 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202788#M1251588 sunny_talwar 2016-10-05T12:20:49Z Re: Problem with aggregate function https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202789#M1251590 <HTML><HEAD></HEAD><BODY><P>Hi Sunny</P><P></P><P>Total GP for the month divided by total sales for the month and multiplied by the sales of that Item for the month</P></BODY></HTML> Wed, 05 Oct 2016 12:24:36 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202789#M1251590 pkpandey 2016-10-05T12:24:36Z Re: Problem with aggregate function https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202790#M1251591 <HTML><HEAD></HEAD><BODY><P>Try this expression. You overally complicated your expression before</P><P></P><P><STRONG>=Sum(Total {&lt;Item&gt;} GP)/Sum(Total {&lt;Item&gt;} Sales) * Sum(Sales)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139687_Capture.PNG" style="height: 154px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Wed, 05 Oct 2016 12:29:28 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202790#M1251591 sunny_talwar 2016-10-05T12:29:28Z Re: Problem with aggregate function https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202791#M1251593 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Sum(Total {1} GP)/Sum(Total {1} Sales) * Sum(Sales)</STRONG></P></BODY></HTML> Wed, 05 Oct 2016 12:29:45 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202791#M1251593 sunny_talwar 2016-10-05T12:29:45Z Re: Problem with aggregate function https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202792#M1251595 <HTML><HEAD></HEAD><BODY><P>Many thanks</P></BODY></HTML> Wed, 05 Oct 2016 12:35:41 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggregate-function/m-p/1202792#M1251595 pkpandey 2016-10-05T12:35:41Z