https://community.qlik.com/t5/QlikView/aggr-e-sum/m-p/1743825#M724880 <P>yes Aggr() will help you.</P><P>try below</P><P>Sum(Aggr(Your_Current_Expression,All_the_dimension_which_you_have_in_chart))</P><P>&nbsp;</P><P>Regards,</P><P>Prashant Sangle</P> Tue, 15 Sep 2020 07:04:54 GMT PrashantSangle 2020-09-15T07:04:54Z https://community.qlik.com/t5/QlikView/aggr-e-sum/m-p/1709623#M724879 <P>Salve a tutti,</P><P>Io ho una tabella dove la somma delle righe non torna con il totale</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="claudio__lamonaca_0-1591772169130.png" style="width: 170px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/35267i5C347AA7F27404E6/image-dimensions/170x402?v=v2" width="170" height="402" role="button" title="claudio__lamonaca_0-1591772169130.png" alt="claudio__lamonaca_0-1591772169130.png" /></span></P><P>il problema credo sia nella setanalysis</P><P>(SUM(total &lt;CEF.CFOR, CEF.TAAD, ABASSO.ARTICOLO_COMPLETO&gt; VENDITE.NET_SC_NET_IVA) / SUM(total &lt;CEF.CFOR, CEF.TAAD, ABASSO.ARTICOLO_COMPLETO&gt; VENDITE.QTA_VENDUTE))<BR />*SUM(total &lt;CEF.CFOR, CEF.TAAD, ABASSO.ARTICOLO_COMPLETO&gt; RIGA.QR01YBC)</P><P>&nbsp;</P><P>credo che dovrei utilizzare la aggr e la sum annidate in qualche maniera per poter far si che la somma delle righe e il totale mi corrispondano</P><P>&nbsp;</P><P>grazie in anticipo</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/aggr-e-sum/m-p/1709623#M724879 claudio__lamonaca 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/aggr-e-sum/m-p/1743825#M724880 <P>yes Aggr() will help you.</P><P>try below</P><P>Sum(Aggr(Your_Current_Expression,All_the_dimension_which_you_have_in_chart))</P><P>&nbsp;</P><P>Regards,</P><P>Prashant Sangle</P> Tue, 15 Sep 2020 07:04:54 GMT https://community.qlik.com/t5/QlikView/aggr-e-sum/m-p/1743825#M724880 PrashantSangle 2020-09-15T07:04:54Z