topic Re: SUM Column in text field in QlikView https://community.qlik.com/t5/QlikView/SUM-Column-in-text-field/m-p/447954#M558122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 06 Jun 2013 15:22:58 GMT jagan 2013-06-06T15:22:58Z SUM Column in text field https://community.qlik.com/t5/QlikView/SUM-Column-in-text-field/m-p/447953#M558121 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Short question, I'm trying to calculate the total of an expression. The expression is positioned in an pivot table. How can i create a SUM of the expession in a textfield outside the pivottable?</P><P></P><P>Inside the table i use the following: =sum(Amount)*[UnitValue]</P><P></P><P>The goal is to sum the total hours in the data show in the table in a text field next to the table. look at the example below</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Projectnumber</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Unit</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Unitvalue<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total in hours</STRONG></SPAN></TH></TR><TR><TD>David</TD><TD>126456345612</TD><TD>Hour</TD><TD>1</TD><TD>12</TD><TD>12</TD></TR><TR><TD>Mark</TD><TD>312413534634</TD><TD>Day</TD><TD>8</TD><TD>4</TD><TD>32</TD></TR></TBODY></TABLE><P></P><P>How can i Sum the Total in hours column? </P><P></P><P>Kind regards,</P><P></P><P>Marco</P></BODY></HTML> Thu, 06 Jun 2013 14:47:04 GMT https://community.qlik.com/t5/QlikView/SUM-Column-in-text-field/m-p/447953#M558121 2013-06-06T14:47:04Z Re: SUM Column in text field https://community.qlik.com/t5/QlikView/SUM-Column-in-text-field/m-p/447954#M558122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 06 Jun 2013 15:22:58 GMT https://community.qlik.com/t5/QlikView/SUM-Column-in-text-field/m-p/447954#M558122 jagan 2013-06-06T15:22:58Z Re: SUM Column in text field https://community.qlik.com/t5/QlikView/SUM-Column-in-text-field/m-p/447955#M558123 <HTML><HEAD></HEAD><BODY><P>Thanks alot for your help!</P></BODY></HTML> Thu, 06 Jun 2013 16:51:13 GMT https://community.qlik.com/t5/QlikView/SUM-Column-in-text-field/m-p/447955#M558123 2013-06-06T16:51:13Z