topic Sum in load script with two dependent fields in QlikView https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505103#M188826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to calculate a sum in a script, currently I'm running out of ideas...</P><P></P><P>The table looks similar to this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Main</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sub</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value of Sub</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A.1</TD><TD style="padding: 2px;">450</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A.2</TD><TD style="padding: 2px;">550</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A.3</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B.1</TD><TD style="padding: 2px;">460</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C.1</TD><TD style="padding: 2px;">540</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C.2</TD><TD style="padding: 2px;">300</TD></TR></TBODY></TABLE><P></P><P>What I would need now is a sum for Main element A,B,C in a new field of the same table. How can I achieve this?</P><P></P><P>Thanks&amp;Regards</P><P>Jens</P></BODY></HTML> Tue, 22 Oct 2013 13:28:30 GMT 2013-10-22T13:28:30Z Sum in load script with two dependent fields https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505103#M188826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to calculate a sum in a script, currently I'm running out of ideas...</P><P></P><P>The table looks similar to this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Main</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sub</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value of Sub</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A.1</TD><TD style="padding: 2px;">450</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A.2</TD><TD style="padding: 2px;">550</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">A.3</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">B.1</TD><TD style="padding: 2px;">460</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C.1</TD><TD style="padding: 2px;">540</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">C.2</TD><TD style="padding: 2px;">300</TD></TR></TBODY></TABLE><P></P><P>What I would need now is a sum for Main element A,B,C in a new field of the same table. How can I achieve this?</P><P></P><P>Thanks&amp;Regards</P><P>Jens</P></BODY></HTML> Tue, 22 Oct 2013 13:28:30 GMT https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505103#M188826 2013-10-22T13:28:30Z Re: Sum in load script with two dependent fields https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505104#M188827 <HTML><HEAD></HEAD><BODY><P>Could you explain breif</P><P></P><P>Load</P><P>Main,</P><P>sum(Main) as Main1,</P><P>Sub,</P><P>Value</P><P>from table</P><P>groupby Main,</P><P>Sub,</P><P>Value;</P><P></P><P>try like this.......... hope it is helpful </P></BODY></HTML> Tue, 22 Oct 2013 13:33:42 GMT https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505104#M188827 2013-10-22T13:33:42Z Re: Sum in load script with two dependent fields https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505105#M188828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached app :</P></BODY></HTML> Tue, 22 Oct 2013 13:39:10 GMT https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505105#M188828 2013-10-22T13:39:10Z Re: Sum in load script with two dependent fields https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505106#M188829 <HTML><HEAD></HEAD><BODY><P>This is working perfectly fine, thanks. </P></BODY></HTML> Tue, 22 Oct 2013 14:00:12 GMT https://community.qlik.com/t5/QlikView/Sum-in-load-script-with-two-dependent-fields/m-p/505106#M188829 2013-10-22T14:00:12Z