topic Group Calculation in QlikView https://community.qlik.com/t5/QlikView/Group-Calculation/m-p/676649#M1068939 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65570_Screenshot.png" style="width: 779px; height: 463px;" /></P><P>In this table I am having trouble trying to calculate the Day 01 Weight column. If I select a certain group code it gives me the correct amount, but I need the table to give the correct amount by Group Cd without having to select one. Any help on this will be greatly appreciated.&nbsp; </P></BODY></HTML> Fri, 29 Aug 2014 17:29:32 GMT Anonymous 2014-08-29T17:29:32Z Group Calculation https://community.qlik.com/t5/QlikView/Group-Calculation/m-p/676649#M1068939 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65570_Screenshot.png" style="width: 779px; height: 463px;" /></P><P>In this table I am having trouble trying to calculate the Day 01 Weight column. If I select a certain group code it gives me the correct amount, but I need the table to give the correct amount by Group Cd without having to select one. Any help on this will be greatly appreciated.&nbsp; </P></BODY></HTML> Fri, 29 Aug 2014 17:29:32 GMT https://community.qlik.com/t5/QlikView/Group-Calculation/m-p/676649#M1068939 Anonymous 2014-08-29T17:29:32Z Re: Group Calculation https://community.qlik.com/t5/QlikView/Group-Calculation/m-p/676650#M1068940 <HTML><HEAD></HEAD><BODY><P>hi there i downlowed your qvw and tried this. Does it work ? </P><P></P><P></P><P>Sum(Total &lt;Project_#&gt; fDay1_wt * Aggr(Sum(Head_Start), fDay1_wt,Project_#))</P><P>/ </P><P>Sum(Total &lt;Project_#&gt; Aggr(Sum(Head_Start), fDay1_wt,Project_#))</P></BODY></HTML> Fri, 29 Aug 2014 18:07:54 GMT https://community.qlik.com/t5/QlikView/Group-Calculation/m-p/676650#M1068940 JonnyPoole 2014-08-29T18:07:54Z Re: Group Calculation https://community.qlik.com/t5/QlikView/Group-Calculation/m-p/676651#M1068941 <HTML><HEAD></HEAD><BODY><P>Awesome job, thank you.</P></BODY></HTML> Fri, 29 Aug 2014 20:16:45 GMT https://community.qlik.com/t5/QlikView/Group-Calculation/m-p/676651#M1068941 Anonymous 2014-08-29T20:16:45Z