topic subtract two columns in QlikView in App Development

topic subtract two columns in QlikView in App Development https://community.qlik.com/t5/App-Development/subtract-two-columns-in-QlikView/m-p/1813969#M66523 <P>Hi,</P><P>What's the better way to  calculate the output table based on input table below?</P><P>Category, state are dimensions. Amount fields are expressions in a straight table in QlikView.</P><P>Input:</P><TABLE><TBODY><TR><TD><STRONG>Category</STRONG></TD><TD><STRONG>State</STRONG></TD><TD><STRONG>Amount1</STRONG></TD><TD><STRONG>Amount2</STRONG></TD></TR><TR><TD>A1</TD><TD>CA</TD><TD>                 -  </TD><TD>             1,000</TD></TR><TR><TD>A1</TD><TD>NY</TD><TD>                 -  </TD><TD>             1,500</TD></TR><TR><TD>B2</TD><TD>CA</TD><TD>           5,000</TD><TD>                   -  </TD></TR><TR><TD>B2</TD><TD>NY</TD><TD>           4,500</TD><TD>                   -  </TD></TR></TBODY></TABLE><P> </P><P>Output:</P><TABLE><TBODY><TR><TD><STRONG>Category</STRONG></TD><TD><STRONG>State</STRONG></TD><TD><STRONG>Amount</STRONG></TD></TR><TR><TD>B2</TD><TD>CA</TD><TD>           4,000</TD></TR><TR><TD>B2</TD><TD>NY</TD><TD>           3,000</TD></TR></TBODY></TABLE> Wed, 09 Jun 2021 17:24:51 GMT newqlik2017 2021-06-09T17:24:51Z subtract two columns in QlikView https://community.qlik.com/t5/App-Development/subtract-two-columns-in-QlikView/m-p/1813969#M66523 <P>Hi,</P><P>What's the better way to  calculate the output table based on input table below?</P><P>Category, state are dimensions. Amount fields are expressions in a straight table in QlikView.</P><P>Input:</P><TABLE><TBODY><TR><TD><STRONG>Category</STRONG></TD><TD><STRONG>State</STRONG></TD><TD><STRONG>Amount1</STRONG></TD><TD><STRONG>Amount2</STRONG></TD></TR><TR><TD>A1</TD><TD>CA</TD><TD>                 -  </TD><TD>             1,000</TD></TR><TR><TD>A1</TD><TD>NY</TD><TD>                 -  </TD><TD>             1,500</TD></TR><TR><TD>B2</TD><TD>CA</TD><TD>           5,000</TD><TD>                   -  </TD></TR><TR><TD>B2</TD><TD>NY</TD><TD>           4,500</TD><TD>                   -  </TD></TR></TBODY></TABLE><P> </P><P>Output:</P><TABLE><TBODY><TR><TD><STRONG>Category</STRONG></TD><TD><STRONG>State</STRONG></TD><TD><STRONG>Amount</STRONG></TD></TR><TR><TD>B2</TD><TD>CA</TD><TD>           4,000</TD></TR><TR><TD>B2</TD><TD>NY</TD><TD>           3,000</TD></TR></TBODY></TABLE> Wed, 09 Jun 2021 17:24:51 GMT https://community.qlik.com/t5/App-Development/subtract-two-columns-in-QlikView/m-p/1813969#M66523 newqlik2017 2021-06-09T17:24:51Z Re: subtract two columns in QlikView https://community.qlik.com/t5/App-Development/subtract-two-columns-in-QlikView/m-p/1813995#M66525 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/23785">@newqlik2017</a>  can you elaborate ?</P> Wed, 09 Jun 2021 19:43:06 GMT https://community.qlik.com/t5/App-Development/subtract-two-columns-in-QlikView/m-p/1813995#M66525 Taoufiq_Zarra 2021-06-09T19:43:06Z