https://community.qlik.com/t5/App-Development/Trouble-with-normalizing-the-data-in-a-chart/m-p/1986325#M81488 <P>I'm not sure if there is any aggr() needed. Just try it with:</P> <P><SPAN>Sum(RejectQty)/sum(OutputQty)</SPAN></P> <P>without an aggr(). If this doesn't returned the expected values then transfer all dimensions and expressions into a table-chart. Usually it's much easier to detect the issues within the data and/or the logic as within any graphically chart.</P> <P>- Marcus</P> Wed, 28 Sep 2022 06:38:29 GMT marcus_sommer 2022-09-28T06:38:29Z https://community.qlik.com/t5/App-Development/Trouble-with-normalizing-the-data-in-a-chart/m-p/1986021#M81438 <P><SPAN>&nbsp;I am trying to create a simple bar chart of normalized reject quantities for different reject event names.&nbsp; I have all of the data in a single table.&nbsp; Columns are OutputQty, RejectQty, RejectName, and Equipment.&nbsp; Sum(RejectQty) works fine.&nbsp; Sum(OutputQty) also works fine.&nbsp; I have tried multiple version with the aggr function, but I cannot get any version of the&nbsp; Sum(RejectQty)/sum(OutputQty) to work.&nbsp; The reject qty&nbsp;values are null, when the output quantity values are not missing, and the output qty is null, when the reject values are not missing.</SPAN></P> Tue, 27 Sep 2022 12:59:51 GMT https://community.qlik.com/t5/App-Development/Trouble-with-normalizing-the-data-in-a-chart/m-p/1986021#M81438 jonfisher 2022-09-27T12:59:51Z https://community.qlik.com/t5/App-Development/Trouble-with-normalizing-the-data-in-a-chart/m-p/1986325#M81488 <P>I'm not sure if there is any aggr() needed. Just try it with:</P> <P><SPAN>Sum(RejectQty)/sum(OutputQty)</SPAN></P> <P>without an aggr(). If this doesn't returned the expected values then transfer all dimensions and expressions into a table-chart. Usually it's much easier to detect the issues within the data and/or the logic as within any graphically chart.</P> <P>- Marcus</P> Wed, 28 Sep 2022 06:38:29 GMT https://community.qlik.com/t5/App-Development/Trouble-with-normalizing-the-data-in-a-chart/m-p/1986325#M81488 marcus_sommer 2022-09-28T06:38:29Z