topic Re: Triying to sum amounts in the script from different fields on a mapping load in QlikView https://community.qlik.com/t5/QlikView/Triying-to-sum-amounts-in-the-script-from-different-fields-on-a/m-p/674824#M245023 <HTML><HEAD></HEAD><BODY><P>In you mapping tables, you can sum the amounts and group by InvoiceNumber</P><P></P><P>SALESFOB:</P><P>MAPPING LOAD INVOICENUMBER, sum(FOB€)</P><P>Resident SALES GROUP BY INVOICENUMBER;</P></BODY></HTML> Tue, 23 Sep 2014 15:26:10 GMT geert_gelade 2014-09-23T15:26:10Z Triying to sum amounts in the script from different fields on a mapping load https://community.qlik.com/t5/QlikView/Triying-to-sum-amounts-in-the-script-from-different-fields-on-a/m-p/674823#M245022 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm desperate with this one...</P><P></P><P>I'm using a mapping load to get two kind of amounts (sales price and sales cost):</P><P></P><P><IMG alt="QV1.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/67458_QV1.bmp" /></P><P></P><P>Then I'm bringing the two fields into other table:</P><P><IMG alt="QV2.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/67463_QV2.bmp" /></P><P>The only fields in common between this files are "letter" and "invoice" (the ones that I'm using for the mapping).</P><P>Mi problem is: in the first file (SALES) there is a sub-invoice field; example:</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" 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">Letter</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Invoice</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P>Subinvoice</P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">FOB€</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">COST€</TH></TR><TR><TD style="padding: 2px;"><P>A</P></TD><TD style="padding: 2px;">1405</TD><TD style="padding: 2px;">01</TD><TD style="padding: 2px;">1.200€</TD><TD style="padding: 2px;">1.050€</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1405</TD><TD style="padding: 2px;">02</TD><TD style="padding: 2px;">456€</TD><TD style="padding: 2px;">432€</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1405</TD><TD style="padding: 2px;">03</TD><TD style="padding: 2px;">926€</TD><TD style="padding: 2px;">817€</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1405</TD><TD style="padding: 2px;">04</TD><TD style="padding: 2px;">621€</TD><TD style="padding: 2px;">635€</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1405</TD><TD style="padding: 2px;">05</TD><TD style="padding: 2px;">325€</TD><TD style="padding: 2px;">323€</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1405</TD><TD style="padding: 2px;">06</TD><TD style="padding: 2px;">211€</TD><TD style="padding: 2px;">225€</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1405</TD><TD style="padding: 2px;">07</TD><TD style="padding: 2px;">1.012€</TD><TD style="padding: 2px;">903€</TD></TR></TBODY></TABLE><P></P><P>The mapping only gives me the first of this amounts, How can I get the total sum of them?? I need to do this in the script!!</P><P></P><P>Note that I'm using an ODBC database, I'm not using excel or access files.</P></BODY></HTML> Tue, 23 Sep 2014 15:18:31 GMT https://community.qlik.com/t5/QlikView/Triying-to-sum-amounts-in-the-script-from-different-fields-on-a/m-p/674823#M245022 2014-09-23T15:18:31Z Re: Triying to sum amounts in the script from different fields on a mapping load https://community.qlik.com/t5/QlikView/Triying-to-sum-amounts-in-the-script-from-different-fields-on-a/m-p/674824#M245023 <HTML><HEAD></HEAD><BODY><P>In you mapping tables, you can sum the amounts and group by InvoiceNumber</P><P></P><P>SALESFOB:</P><P>MAPPING LOAD INVOICENUMBER, sum(FOB€)</P><P>Resident SALES GROUP BY INVOICENUMBER;</P></BODY></HTML> Tue, 23 Sep 2014 15:26:10 GMT https://community.qlik.com/t5/QlikView/Triying-to-sum-amounts-in-the-script-from-different-fields-on-a/m-p/674824#M245023 geert_gelade 2014-09-23T15:26:10Z Re: Triying to sum amounts in the script from different fields on a mapping load https://community.qlik.com/t5/QlikView/Triying-to-sum-amounts-in-the-script-from-different-fields-on-a/m-p/674825#M245024 <HTML><HEAD></HEAD><BODY><P>Great <A href="https://community.qlik.com/qlik-users/65617">Geert Gelade</A>!! It works!!</P><P></P><P>Thank you so much!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Tue, 23 Sep 2014 15:57:02 GMT https://community.qlik.com/t5/QlikView/Triying-to-sum-amounts-in-the-script-from-different-fields-on-a/m-p/674825#M245024 2014-09-23T15:57:02Z