topic Re: Total Row in QlikView https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092544#M927180 <HTML><HEAD></HEAD><BODY><P>Add a dimension? Not sure I understand? Which table are we wanting to fix? the top one or the bottom one and which expression?</P></BODY></HTML> Tue, 29 Mar 2016 22:46:46 GMT sunny_talwar 2016-03-29T22:46:46Z Total Row https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092540#M927176 <HTML><HEAD></HEAD><BODY><P>Hi, in the attached example, I don´t know how to get the correct Total Value for the <STRONG>Final Balance</STRONG> column, as you can see the Total row is not showing the correct value of the detail sum that should be 210.</P><P></P><P>Any idea of how can I get it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092540#M927176 2020-11-25T16:16:04Z Re: Total Row https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092541#M927177 <HTML><HEAD></HEAD><BODY><P>Try the attached</P><P></P><P><IMG __jive_id="119713" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119713_Capture.PNG" style="height: 523px; width: 620px;" /></P></BODY></HTML> Tue, 29 Mar 2016 16:37:50 GMT https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092541#M927177 sunny_talwar 2016-03-29T16:37:50Z Re: Total Row https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092542#M927178 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Great, now taking one step further, if I add a extra dimesion&nbsp; how could I get the same result</SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG alt="ST.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119706_ST.png" style="height: auto;" /><BR /></SPAN></P><P></P></BODY></HTML> Tue, 29 Mar 2016 17:14:49 GMT https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092542#M927178 2016-03-29T17:14:49Z Re: Total Row https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092543#M927179 <HTML><HEAD></HEAD><BODY><P>Try this!, on the chart properties</P><P><IMG alt="211291.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119715_211291.png" style="height: 547px; width: 620px;" /></P><P></P><P>Best regard!</P><P></P><P>Agustin</P></BODY></HTML> Tue, 29 Mar 2016 17:24:55 GMT https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092543#M927179 agustinbobba 2016-03-29T17:24:55Z Re: Total Row https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092544#M927180 <HTML><HEAD></HEAD><BODY><P>Add a dimension? Not sure I understand? Which table are we wanting to fix? the top one or the bottom one and which expression?</P></BODY></HTML> Tue, 29 Mar 2016 22:46:46 GMT https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092544#M927180 sunny_talwar 2016-03-29T22:46:46Z Re: Total Row https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092545#M927181 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Sum(Aggr(if(aggr(sum(Forecast),Cod_prod)*vCost &gt;aggr(sum(Balance),Cod_prod),sum(Balance),sum(Forecast)*vCost), Region, Cod_prod))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119757_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 29 Mar 2016 22:49:26 GMT https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092545#M927181 sunny_talwar 2016-03-29T22:49:26Z Re: Total Row https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092546#M927182 <HTML><HEAD></HEAD><BODY><P>Thanks, that's exactly what I want</P></BODY></HTML> Tue, 29 Mar 2016 23:55:12 GMT https://community.qlik.com/t5/QlikView/Total-Row/m-p/1092546#M927182 2016-03-29T23:55:12Z