topic Re: Sum & Aggregation in QlikView https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724502#M1051602 <HTML><HEAD></HEAD><BODY><P>I Believe SET analysis not worked in the load script.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 29 Oct 2014 18:35:51 GMT its_anandrjs 2014-10-29T18:35:51Z Sum & Aggregation https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724501#M1051601 <HTML><HEAD></HEAD><BODY><P><IMG alt="screenshot.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/70021_screenshot.jpg" style="width: 620px; height: 195px;" /></P><P></P><P>Hi,</P><P></P><P>Could anybody help my with that mistake in the Sum-Formula? Is the Statement to Group by OverallTransactionDate correct for an aggregration of the sum?</P><P></P><P>Many thanks in advance.</P><P></P><P>Carolin </P></BODY></HTML> Wed, 29 Oct 2014 18:25:46 GMT https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724501#M1051601 carolin01 2014-10-29T18:25:46Z Re: Sum & Aggregation https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724502#M1051602 <HTML><HEAD></HEAD><BODY><P>I Believe SET analysis not worked in the load script.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 29 Oct 2014 18:35:51 GMT https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724502#M1051602 its_anandrjs 2014-10-29T18:35:51Z Re: Sum & Aggregation https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724503#M1051603 <HTML><HEAD></HEAD><BODY><P>May be try different ways</P><P><STRONG><EM><BR /></EM></STRONG></P><P><STRONG><EM>Load </EM></STRONG></P><P><EM><STRONG>OveralTransactionDate,</STRONG></EM></P><P><EM><STRONG>Sum( If(OrderPhase_Desc = 'Revenue' ,&nbsp; NettAmountUSD)) as SalesNettAmountUSD</STRONG></EM></P><P><STRONG><EM>From Location </EM></STRONG></P><P><STRONG><EM>Group By OverallTransactionDate;</EM></STRONG></P><P></P><P>Sorry i forget to add the Group by line</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 29 Oct 2014 18:38:03 GMT https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724503#M1051603 its_anandrjs 2014-10-29T18:38:03Z Re: Sum & Aggregation https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724504#M1051604 <HTML><HEAD></HEAD><BODY><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OverallTransactionDate,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum(NettAmountUSD) as SalesNettAmountUSD</P><P>From</P><P><C> (qvd)</C></P><P>Where OrderPhase_Desc = 'Revenue'</P><P>Group by OverallTransactionDate</P></BODY></HTML> Wed, 29 Oct 2014 18:46:41 GMT https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724504#M1051604 Anonymous 2014-10-29T18:46:41Z Re: Sum & Aggregation https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724505#M1051605 <HTML><HEAD></HEAD><BODY><P>Many thanks for your quick help!!</P></BODY></HTML> Wed, 29 Oct 2014 18:54:03 GMT https://community.qlik.com/t5/QlikView/Sum-Aggregation/m-p/724505#M1051605 carolin01 2014-10-29T18:54:03Z