topic Re: Problem with total summate and partial summate in a straight chart in QlikView https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761442#M454053 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/36023">@geogou1973</a>&nbsp;<BR /><BR />Try like below</P><P>Purchases Amount with AVG Sale Price:<BR />If(IsNull(RowNo()) or RowNo() = 0, Sum(Aggr(Sum([Purchases Qty]) * (Sum([Sales Amount]) / Sum([Sales Qty])), Customer, Item)),<BR />Sum([Purchases Qty]) * (Sum([Sales Amount]) / Sum([Sales Qty])))</P> Fri, 13 Nov 2020 08:03:26 GMT MayilVahanan 2020-11-13T08:03:26Z Problem with total summate and partial summate in a straight chart https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761433#M454052 <P>Hello,</P><P>I have problem with total summate and partial summate in a straight chart.</P><P>I upload sales and purchases in some items i don't have sales and in other i don't have purchases for the same period.</P><P>The problem is in the column&nbsp;<STRONG>Purchases Amount with AVG Sale Price.&nbsp;</STRONG></P><P>The expression is&nbsp;Purchases Qty*(Sales Amount/Sales Qty)</P><P>if you summate the partial rows you have 229,93 and in the total row the chart shows 239,46 with total mode (Expression Total) , if you change the total mode to (Sum of Rows) you have the correct summate 229,93.</P><P>The problem begins when i summate only in the customer. In this case the amount does not change i have&nbsp;&nbsp;239,46</P><P>I tried to change the expression to&nbsp;</P><P>SUM([Purchases Qty])<BR />*<BR />(sum({&lt;Item= {"=sum([Purchases Qty]) &lt;&gt; 0"}&gt;} [Sales Amount])<BR />/<BR />sum({&lt;Item= {"=sum([Purchases Qty]) &lt;&gt; 0"}&gt;} [Sales Qty]))&nbsp;</P><P>but the total amount is 251,7 that is not correct.</P><P>Can anyone help in this case ?</P><P>Thank you in advance.</P><TABLE><TBODY><TR><TD>Customer</TD><TD>Item</TD><TD>Sales Qty</TD><TD>Sales Amount</TD><TD>AVG Sales Price</TD><TD>Purchases Qty</TD><TD><STRONG>Purchases Amount with AVG Sale Price</STRONG></TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>145,00</TD><TD>201,87</TD><TD>&nbsp;</TD><TD>172,00</TD><TD><STRONG>239,46</STRONG></TD></TR><TR><TD>022447945</TD><TD>111164</TD><TD>9,00</TD><TD>7,54</TD><TD>0,84</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>111357</TD><TD>3,00</TD><TD>7,44</TD><TD>2,48</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>111854</TD><TD>18,00</TD><TD>9,90</TD><TD>0,55</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>113756</TD><TD>4,00</TD><TD>8,00</TD><TD>2,00</TD><TD>12,00</TD><TD>24,00</TD></TR><TR><TD>022447945</TD><TD>116373</TD><TD>15,00</TD><TD>6,00</TD><TD>0,40</TD><TD>48,00</TD><TD>19,20</TD></TR><TR><TD>022447945</TD><TD>119626</TD><TD>4,00</TD><TD>1,64</TD><TD>0,41</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>120485</TD><TD>10,00</TD><TD>16,95</TD><TD>1,70</TD><TD>19,00</TD><TD>32,21</TD></TR><TR><TD>022447945</TD><TD>121408</TD><TD>10,00</TD><TD>22,20</TD><TD>2,22</TD><TD>16,00</TD><TD>35,52</TD></TR><TR><TD>022447945</TD><TD>121496</TD><TD>10,00</TD><TD>11,15</TD><TD>1,12</TD><TD>25,00</TD><TD>27,88</TD></TR><TR><TD>022447945</TD><TD>122850</TD><TD>2,00</TD><TD>8,90</TD><TD>4,45</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>123709</TD><TD>3,00</TD><TD>13,38</TD><TD>4,46</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>129563</TD><TD>3,00</TD><TD>3,09</TD><TD>1,03</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>134488</TD><TD>8,00</TD><TD>16,00</TD><TD>2,00</TD><TD>10,00</TD><TD>20,00</TD></TR><TR><TD>022447945</TD><TD>140278</TD><TD>5,00</TD><TD>10,20</TD><TD>2,04</TD><TD>6,00</TD><TD>12,24</TD></TR><TR><TD>022447945</TD><TD>142798</TD><TD>1,00</TD><TD>3,24</TD><TD>3,24</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>145606</TD><TD>12,00</TD><TD>23,52</TD><TD>1,96</TD><TD>24,00</TD><TD>47,04</TD></TR><TR><TD>022447945</TD><TD>148173</TD><TD>2,00</TD><TD>3,84</TD><TD>1,92</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>148324</TD><TD>7,00</TD><TD>9,82</TD><TD>1,40</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>148441</TD><TD>1,00</TD><TD>0,58</TD><TD>0,58</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>148501</TD><TD>1,00</TD><TD>2,35</TD><TD>2,35</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>148745</TD><TD>1,00</TD><TD>0,58</TD><TD>0,58</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>148831</TD><TD>12,00</TD><TD>11,85</TD><TD>0,99</TD><TD>12,00</TD><TD>11,85</TD></TR><TR><TD>022447945</TD><TD>148842</TD><TD>2,00</TD><TD>2,00</TD><TD>1,00</TD><TD>0,00</TD><TD>0,00</TD></TR><TR><TD>022447945</TD><TD>148878</TD><TD>2,00</TD><TD>1,70</TD><TD>0,85</TD><TD>0,00</TD><TD>0,00</TD></TR></TBODY></TABLE> Fri, 13 Nov 2020 07:30:15 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761433#M454052 geogou1973 2020-11-13T07:30:15Z Re: Problem with total summate and partial summate in a straight chart https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761442#M454053 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/36023">@geogou1973</a>&nbsp;<BR /><BR />Try like below</P><P>Purchases Amount with AVG Sale Price:<BR />If(IsNull(RowNo()) or RowNo() = 0, Sum(Aggr(Sum([Purchases Qty]) * (Sum([Sales Amount]) / Sum([Sales Qty])), Customer, Item)),<BR />Sum([Purchases Qty]) * (Sum([Sales Amount]) / Sum([Sales Qty])))</P> Fri, 13 Nov 2020 08:03:26 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761442#M454053 MayilVahanan 2020-11-13T08:03:26Z Re: Problem with total summate and partial summate in a straight chart https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761447#M454054 <P>Hello and thank you for the response.</P><P>In the chart a have only the dimension of the customer the expression works correctly in the total summate with&nbsp;<SPAN>total mode (Expression Total)&nbsp; but in the partial does not work. I have different amount.</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 13 Nov 2020 08:39:12 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761447#M454054 geogou1973 2020-11-13T08:39:12Z Re: Problem with total summate and partial summate in a straight chart https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761448#M454055 <P>I changed the expression to&nbsp;</P><P>Sum(Aggr(Sum(PURCH_QTY) *<BR />(Sum(SALES_AMT) / Sum(SALES_QTY)), CUST01, ITEM_ID))</P><P>and worked.</P><P>Thank you very much.</P><P>&nbsp;</P> Fri, 13 Nov 2020 08:52:14 GMT https://community.qlik.com/t5/QlikView/Problem-with-total-summate-and-partial-summate-in-a-straight/m-p/1761448#M454055 geogou1973 2020-11-13T08:52:14Z