topic Re: Total Sum Split Expression in QlikView https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299594#M836014 <HTML><HEAD></HEAD><BODY><P>What is your expected output ? I don't see a field [Total Ransomes Freight Charge] in your data model ...?</P></BODY></HTML> Fri, 19 May 2017 11:35:26 GMT trdandamudi 2017-05-19T11:35:26Z Total Sum Split Expression https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299593#M836013 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I need to get a sum of a split charges expression. The expression was previously created as I need only 1 charge of 19.64 per Dealer per day. But now I need to sum these individual 19.64 charges to get a total per dealer. I have the split sum working in the pivot table fine but now i need to sum those 19.64s to create a variance against the other freight charge for the Total Freight Charge table.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I've attached a qvw with the different expressions in it to see if anyone can help. The TOTAL expression messes it up slightly <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299593#M836013 khaycock 2020-11-25T16:16:04Z Re: Total Sum Split Expression https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299594#M836014 <HTML><HEAD></HEAD><BODY><P>What is your expected output ? I don't see a field [Total Ransomes Freight Charge] in your data model ...?</P></BODY></HTML> Fri, 19 May 2017 11:35:26 GMT https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299594#M836014 trdandamudi 2017-05-19T11:35:26Z Re: Total Sum Split Expression https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299595#M836015 <HTML><HEAD></HEAD><BODY><P>I need a sum of all 'Split UPS Freight Charges' for each 'Dealer' </P></BODY></HTML> Fri, 19 May 2017 13:07:43 GMT https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299595#M836015 khaycock 2017-05-19T13:07:43Z Re: Total Sum Split Expression https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299596#M836016 <HTML><HEAD></HEAD><BODY><P>What is a numeric output you are expecting to see and which of the two charts? If this is for the Total Freight Charge, may be this</P><P></P><P><STRONG>Sum(Aggr($(vNewIntFreightCharge), ORDER_NUMBER, DATE, Name))</STRONG></P><P></P><P>to get 608.84?</P></BODY></HTML> Fri, 19 May 2017 13:36:10 GMT https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299596#M836016 sunny_talwar 2017-05-19T13:36:10Z Re: Total Sum Split Expression https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299597#M836017 <HTML><HEAD></HEAD><BODY><P>Is this what you are expecting?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164048_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 19 May 2017 13:53:41 GMT https://community.qlik.com/t5/QlikView/Total-Sum-Split-Expression/m-p/1299597#M836017 vishsaggi 2017-05-19T13:53:41Z