https://community.qlik.com/t5/App-Development/Subtracting-same-column-values-in-QlikSense-table-chart/m-p/1995635#M82413 <P>Try</P> <P>Sum(Aggr(Sum({&lt;Business={'Direct'}&gt;}Sales),Month))- Sum(Aggr(Sum({&lt;Business={'Indirect'}&gt;}Sales),Month))</P> Fri, 21 Oct 2022 15:47:07 GMT BrunPierre 2022-10-21T15:47:07Z https://community.qlik.com/t5/App-Development/Subtracting-same-column-values-in-QlikSense-table-chart/m-p/1995555#M82406 <P>Hello All,</P> <P>I have a table chart in frontend which containg data as below</P> <TABLE style="border-collapse: collapse; width: 144pt;" border="0" width="192" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" class="xl67" style="height: 15.0pt; width: 48pt;">Business</TD> <TD width="64" class="xl67" style="border-left: none; width: 48pt;">Month</TD> <TD width="64" class="xl67" style="border-left: none; width: 48pt;">Sales</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Direct</TD> <TD class="xl65" style="border-top: none; border-left: none;">Apr</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">100</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Direct</TD> <TD class="xl65" style="border-top: none; border-left: none;">May</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">200</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Direct</TD> <TD class="xl65" style="border-top: none; border-left: none;">Jun</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Direct</TD> <TD class="xl65" style="border-top: none; border-left: none;">Jul</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">400</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Direct</TD> <TD class="xl65" style="border-top: none; border-left: none;">Aug</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">500</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl66" style="height: 15.0pt; border-top: none;">Indirect</TD> <TD class="xl66" style="border-top: none; border-left: none;">Apr</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">10</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl66" style="height: 15.0pt; border-top: none;">Indirect</TD> <TD class="xl66" style="border-top: none; border-left: none;">May</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">20</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl66" style="height: 15.0pt; border-top: none;">Indirect</TD> <TD class="xl66" style="border-top: none; border-left: none;">Jun</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">30</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl66" style="height: 15.0pt; border-top: none;">Indirect</TD> <TD class="xl66" style="border-top: none; border-left: none;">Jul</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">40</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl66" style="height: 15.0pt; border-top: none;">Indirect</TD> <TD class="xl66" style="border-top: none; border-left: none;">Aug</TD> <TD align="right" class="xl66" style="border-top: none; border-left: none;">50</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to subtract Business=Indirect value for month of Apr from Business=Direct and show in a separate table chart.</P> <P>(here for Apr = 100 - 10). Similar for all months</P> <P>Desired output:</P> <TABLE style="border-collapse: collapse; width: 144pt;" border="0" width="192" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" class="xl66" style="height: 15.0pt; width: 48pt;">Business</TD> <TD width="64" class="xl66" style="border-left: none; width: 48pt;">Month</TD> <TD width="64" class="xl66" style="border-left: none; width: 48pt;">Sales</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Net</TD> <TD class="xl65" style="border-top: none; border-left: none;">Apr</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">90</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Net</TD> <TD class="xl65" style="border-top: none; border-left: none;">May</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">180</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Net</TD> <TD class="xl65" style="border-top: none; border-left: none;">Jun</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">270</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Net</TD> <TD class="xl65" style="border-top: none; border-left: none;">Jul</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">360</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">Net</TD> <TD class="xl65" style="border-top: none; border-left: none;">Aug</TD> <TD align="right" class="xl65" style="border-top: none; border-left: none;">450</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Regards,</P> <P>Aditya</P> Fri, 21 Oct 2022 13:28:48 GMT https://community.qlik.com/t5/App-Development/Subtracting-same-column-values-in-QlikSense-table-chart/m-p/1995555#M82406 Aditya_Chitale 2022-10-21T13:28:48Z https://community.qlik.com/t5/App-Development/Subtracting-same-column-values-in-QlikSense-table-chart/m-p/1995635#M82413 <P>Try</P> <P>Sum(Aggr(Sum({&lt;Business={'Direct'}&gt;}Sales),Month))- Sum(Aggr(Sum({&lt;Business={'Indirect'}&gt;}Sales),Month))</P> Fri, 21 Oct 2022 15:47:07 GMT https://community.qlik.com/t5/App-Development/Subtracting-same-column-values-in-QlikSense-table-chart/m-p/1995635#M82413 BrunPierre 2022-10-21T15:47:07Z