https://community.qlik.com/t5/QlikView/No-sum-for-expression-in-pivot-chart/m-p/1683922#M727359 <P>Have a look at the following Help link for starters:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm</A></P><P>Then you may need to have a look at the following Design Blog post for more info on AGGR:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275</A></P><P>Regards,<BR />Brett</P> Wed, 11 Mar 2020 18:17:13 GMT Brett_Bleess 2020-03-11T18:17:13Z https://community.qlik.com/t5/QlikView/No-sum-for-expression-in-pivot-chart/m-p/1675862#M727358 <P>I am trying to get this expression to provide the correct sum in a pivot chart.&nbsp; It shows a sum of zero instead of the correct summed amount.&nbsp; Any suggestions?</P><P>&nbsp;</P><P>=(If(Match(Account,'Labor','Other ODC','Material/CWT'),</P><P>(((Sum(If(Account='Subcontracts/CWTs',([Cost Amount])))<BR />+<BR />Sum(If(Account='Subcontracts/CWTs',[Cost Amount],)<BR />)*[Material Overhead])<BR />-<BR />Sum(If(Account='Subcontracts/CWTs',([Cost Amount]))))<BR />* [Site Mgmt]</P><P>+</P><P>(Sum(<BR />If([CCP Description]='Mfg Labor (Mfg Proj Mgr)',[Cost Amount]*[Mfg Labor (Mfg Proj Mgr)],<BR />If([CCP Description]='Mfg Labor (Mfg Engineer)',[Cost Amount]*[Mfg Labor (Mfg Engineer)],<BR />If([CCP Description]='Mfg Labor (Mfg Assistant)',[Cost Amount]*[Mfg Labor (Mfg Assistant)],<BR />If([CCP Description]='Eng Labor (Program Mgr)',[Cost Amount]*[Eng Labor (Program Mgr)],<BR />If([CCP Description]='Eng Labor (Senior Systems Eng)',[Cost Amount]*[Eng Labor (Senior Systems Eng)],<BR />If([CCP Description]='Eng Labor (Systems Eng)',[Cost Amount]*[Eng Labor (Systems Eng)],<BR />If([CCP Description]='Eng Labor (Senior Eng)',[Cost Amount]*[Eng Labor (Senior Eng)],<BR />If([CCP Description]='Eng Labor (Engineer)',[Cost Amount]*[Eng Labor (Engineer)],<BR />If([CCP Description]='Eng Labor (Senior Sftwr Eng)',[Cost Amount]*[Eng Labor (Senior Sftwr Eng)],<BR />If([CCP Description]='Eng Labor (Software Eng)',[Cost Amount]*[Eng Labor (Software Eng)],<BR />If([CCP Description]='Eng Labor (Proj Mgr/Adm)',[Cost Amount]*[Eng Labor (Proj Mgr/Adm)],<BR />If([CCP Description]='Eng Labor (Associate Eng)',[Cost Amount]*[Eng Labor (Associate Eng)],<BR />If([CCP Description]='Eng Labor (Eng Assistant)',[Cost Amount]*[Eng Labor (Eng Assistant)],<BR />If([CCP Description]='Touch Discrete',0,<BR />If(Account='Other ODC',[Cost Amount],<BR />If(Account='Travel ODC',[Cost Amount],<BR />If(Account='Material/CWT',<BR />[Cost Amount]*[Material Overhead]<BR />))))))))))))))))))</P><P>+<BR />Sum(<BR />If((Left([CCP Description],9)='Mfg Labor') or Left([CCP Description],14)='Touch Discrete',<BR />(If([CCP Description]='Mfg Labor (Mfg Proj Mgr)',[Cost Amount]*[Mfg Labor (Mfg Proj Mgr)],<BR />If([CCP Description]='Mfg Labor (Mfg Engineer)',[Cost Amount]*[Mfg Labor (Mfg Engineer)],<BR />If([CCP Description]='Mfg Labor (Mfg Assistant)',[Cost Amount]*[Mfg Labor (Mfg Assistant)],<BR />If([CCP Description]='Touch Discrete',[Cost Amount]*[Touch Discrete],Null()<BR />))))<BR />)*[Mfg Labor Overhead],<BR />If(Left([CCP Description],9)='Eng Labor',<BR />( If([CCP Description]='Eng Labor (Program Mgr)',[Cost Amount]*[Eng Labor (Program Mgr)],<BR />If([CCP Description]='Eng Labor (Senior Systems Eng)',[Cost Amount]*[Eng Labor (Senior Systems Eng)],<BR />If([CCP Description]='Eng Labor (Systems Eng)',[Cost Amount]*[Eng Labor (Systems Eng)],<BR />If([CCP Description]='Eng Labor (Senior Eng)',[Cost Amount]*[Eng Labor (Senior Eng)],<BR />If([CCP Description]='Eng Labor (Engineer)',[Cost Amount]*[Eng Labor (Engineer)],<BR />If([CCP Description]='Eng Labor (Senior Sftwr Eng)',[Cost Amount]*[Eng Labor (Senior Sftwr Eng)],<BR />If([CCP Description]='Eng Labor (Software Eng)',[Cost Amount]*[Eng Labor (Software Eng)],<BR />If([CCP Description]='Eng Labor (Proj Mgr/Adm)',[Cost Amount]*[Eng Labor (Proj Mgr/Adm)],<BR />If([CCP Description]='Eng Labor (Associate Eng)',[Cost Amount]*[Eng Labor (Associate Eng)],<BR />If([CCP Description]='Eng Labor (Eng Assistant)',[Cost Amount]*[Eng Labor (Eng Assistant)],Null()<BR />))))))))))<BR />*[Engr Labor Overhead]),<BR /><BR />If(Account='Material/CWT',0,Null(<BR />))))<BR />))* [Site Mgmt]<BR />),sum(If(Match(Account,'Travel ODC','Subcontracts/CWTs'),0))))</P> Sat, 16 Nov 2024 01:16:40 GMT https://community.qlik.com/t5/QlikView/No-sum-for-expression-in-pivot-chart/m-p/1675862#M727358 fanninam 2024-11-16T01:16:40Z https://community.qlik.com/t5/QlikView/No-sum-for-expression-in-pivot-chart/m-p/1683922#M727359 <P>Have a look at the following Help link for starters:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm</A></P><P>Then you may need to have a look at the following Design Blog post for more info on AGGR:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275</A></P><P>Regards,<BR />Brett</P> Wed, 11 Mar 2020 18:17:13 GMT https://community.qlik.com/t5/QlikView/No-sum-for-expression-in-pivot-chart/m-p/1683922#M727359 Brett_Bleess 2020-03-11T18:17:13Z