https://community.qlik.com/t5/QlikView/Getting-a-total-percentage/m-p/1912684#M1218240 <P>I have a chart where I want to show quantity delivered on the due date is or isn't the same as the actual ship date. The Dimension is City. I have two expressions:</P> <P>Order Qty =sum(OrderQuantity)</P> <P>and</P> <P>Order Qty On Time =If(DueDate = ShipDate, sum(OrderQuantity), 0)</P> <P>Everything is fine except when I add a third column for percentage.</P> <P>% Order Qty On Time =[Order Qty On Time] / [Order Qty]</P> <P>The column detail naturally shows either 100% or 0%</P> <P>The problem is on the Total line where nothing I have tried shows the correct percentage which should be around 85%. I've tried multiple combinations using the AGGR or TOTAL functions, but nothing seems to work.</P> <P>Suggestions?</P> <P>See below.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lsmith48461_0-1648748723326.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/75889i4FE3787F15E77117/image-size/medium?v=v2&amp;px=400" role="button" title="lsmith48461_0-1648748723326.png" alt="lsmith48461_0-1648748723326.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 31 Mar 2022 17:45:40 GMT lsmith48461 2022-03-31T17:45:40Z https://community.qlik.com/t5/QlikView/Getting-a-total-percentage/m-p/1912684#M1218240 <P>I have a chart where I want to show quantity delivered on the due date is or isn't the same as the actual ship date. The Dimension is City. I have two expressions:</P> <P>Order Qty =sum(OrderQuantity)</P> <P>and</P> <P>Order Qty On Time =If(DueDate = ShipDate, sum(OrderQuantity), 0)</P> <P>Everything is fine except when I add a third column for percentage.</P> <P>% Order Qty On Time =[Order Qty On Time] / [Order Qty]</P> <P>The column detail naturally shows either 100% or 0%</P> <P>The problem is on the Total line where nothing I have tried shows the correct percentage which should be around 85%. I've tried multiple combinations using the AGGR or TOTAL functions, but nothing seems to work.</P> <P>Suggestions?</P> <P>See below.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lsmith48461_0-1648748723326.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/75889i4FE3787F15E77117/image-size/medium?v=v2&amp;px=400" role="button" title="lsmith48461_0-1648748723326.png" alt="lsmith48461_0-1648748723326.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 31 Mar 2022 17:45:40 GMT https://community.qlik.com/t5/QlikView/Getting-a-total-percentage/m-p/1912684#M1218240 lsmith48461 2022-03-31T17:45:40Z