topic Group by in App Development

topic Group by in App Development https://community.qlik.com/t5/App-Development/Group-by/m-p/2128534#M91804 <P>Dear all,</P> <P>I have table below, I want to create three more columns in back end only.</P> <P>1) Net amount ( which will be Sum of Amt_2 and Amt_1)</P> <P>2) Total amount ( which will be Sum of Amt_2 and Amt_1 year wise )<BR /><BR /></P> <TABLE width="433"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="64">Name</TD> <TD width="64">Address</TD> <TD width="64">Amt_1</TD> <TD width="64">Amt_2</TD> <TD width="113">Date</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>100</TD> <TD>200</TD> <TD>1/10/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>2/10/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>3/10/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>2100</TD> <TD>200</TD> <TD>11/11/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>12/11/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>13/11/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>3100</TD> <TD>200</TD> <TD>21/3/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>22/13/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>23/3/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>1/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>2/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>3/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>4/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>11/11/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>12/11/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>13/4/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>23/4/2023</TD> </TR> </TBODY> </TABLE> <P> </P> <P>In above data, for year 2023, Net amount for John should display </P> <P>800 for Oct month</P> <P>2600 for Nov Month</P> <P>-2200  for March month</P> <P>And for David </P> <P>3250 for Oct</P> <P>1900 for Nov</P> <P>1350 for Apr</P> <P> </P> <P>And last </P> <P>Total Amount Yearwise for John it should display</P> <P>2023 3600</P> <P>and for david</P> <P>2023 19500</P> <P> </P> <P>Final table </P> <TABLE width="840"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="64">Name</TD> <TD width="64">Address</TD> <TD width="64">Amt_1</TD> <TD width="64">Amt_2</TD> <TD width="113">Date</TD> <TD width="96">Net Amount </TD> <TD width="132">Net_Amt_SUM</TD> <TD width="179">Total Amount Yearwise</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>100</TD> <TD>200</TD> <TD>1/10/2023</TD> <TD>100</TD> <TD>800</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>2/10/2023</TD> <TD>300</TD> <TD>800</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>3/10/2023</TD> <TD>400</TD> <TD>800</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>200</TD> <TD>2100</TD> <TD>11/11/2023</TD> <TD>1900</TD> <TD>2600</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>12/11/2023</TD> <TD>300</TD> <TD>2600</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>13/11/2023</TD> <TD>400</TD> <TD>2600</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>3100</TD> <TD>200</TD> <TD>21/3/2023</TD> <TD>-2900</TD> <TD>-2200</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>22/3/2023</TD> <TD>300</TD> <TD>-2200</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>23/3/2023</TD> <TD>400</TD> <TD>-2200</TD> <TD>3600</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>1/10/2023</TD> <TD>700</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>2/10/2023</TD> <TD>1200</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>3/10/2023</TD> <TD>1400</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>4/10/2023</TD> <TD>-50</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>11/11/2023</TD> <TD>700</TD> <TD>1900</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>12/11/2023</TD> <TD>1200</TD> <TD>1900</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>13/4/2023</TD> <TD>1400</TD> <TD>1350</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>23/4/2023</TD> <TD>-50</TD> <TD>1350</TD> <TD>19500</TD> </TR> </TBODY> </TABLE> <P> </P> Sun, 15 Oct 2023 07:47:12 GMT Mahamed_Qlik 2023-10-15T07:47:12Z Group by https://community.qlik.com/t5/App-Development/Group-by/m-p/2128534#M91804 <P>Dear all,</P> <P>I have table below, I want to create three more columns in back end only.</P> <P>1) Net amount ( which will be Sum of Amt_2 and Amt_1)</P> <P>2) Total amount ( which will be Sum of Amt_2 and Amt_1 year wise )<BR /><BR /></P> <TABLE width="433"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="64">Name</TD> <TD width="64">Address</TD> <TD width="64">Amt_1</TD> <TD width="64">Amt_2</TD> <TD width="113">Date</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>100</TD> <TD>200</TD> <TD>1/10/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>2/10/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>3/10/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>2100</TD> <TD>200</TD> <TD>11/11/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>12/11/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>13/11/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>3100</TD> <TD>200</TD> <TD>21/3/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>22/13/2023</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>23/3/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>1/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>2/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>3/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>4/10/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>11/11/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>12/11/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>13/4/2023</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>23/4/2023</TD> </TR> </TBODY> </TABLE> <P> </P> <P>In above data, for year 2023, Net amount for John should display </P> <P>800 for Oct month</P> <P>2600 for Nov Month</P> <P>-2200  for March month</P> <P>And for David </P> <P>3250 for Oct</P> <P>1900 for Nov</P> <P>1350 for Apr</P> <P> </P> <P>And last </P> <P>Total Amount Yearwise for John it should display</P> <P>2023 3600</P> <P>and for david</P> <P>2023 19500</P> <P> </P> <P>Final table </P> <TABLE width="840"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="64">Name</TD> <TD width="64">Address</TD> <TD width="64">Amt_1</TD> <TD width="64">Amt_2</TD> <TD width="113">Date</TD> <TD width="96">Net Amount </TD> <TD width="132">Net_Amt_SUM</TD> <TD width="179">Total Amount Yearwise</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>100</TD> <TD>200</TD> <TD>1/10/2023</TD> <TD>100</TD> <TD>800</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>2/10/2023</TD> <TD>300</TD> <TD>800</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>3/10/2023</TD> <TD>400</TD> <TD>800</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>200</TD> <TD>2100</TD> <TD>11/11/2023</TD> <TD>1900</TD> <TD>2600</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>12/11/2023</TD> <TD>300</TD> <TD>2600</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>13/11/2023</TD> <TD>400</TD> <TD>2600</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD>3100</TD> <TD>200</TD> <TD>21/3/2023</TD> <TD>-2900</TD> <TD>-2200</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>300</TD> <TD>22/3/2023</TD> <TD>300</TD> <TD>-2200</TD> <TD>3600</TD> </TR> <TR> <TD>1</TD> <TD>John</TD> <TD>US</TD> <TD> </TD> <TD>400</TD> <TD>23/3/2023</TD> <TD>400</TD> <TD>-2200</TD> <TD>3600</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>1/10/2023</TD> <TD>700</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>2/10/2023</TD> <TD>1200</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>3/10/2023</TD> <TD>1400</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>4/10/2023</TD> <TD>-50</TD> <TD>3250</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>500</TD> <TD>1200</TD> <TD>11/11/2023</TD> <TD>700</TD> <TD>1900</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>100</TD> <TD>1300</TD> <TD>12/11/2023</TD> <TD>1200</TD> <TD>1900</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD> </TD> <TD>1400</TD> <TD>13/4/2023</TD> <TD>1400</TD> <TD>1350</TD> <TD>19500</TD> </TR> <TR> <TD>2</TD> <TD>David</TD> <TD>UK</TD> <TD>50</TD> <TD> </TD> <TD>23/4/2023</TD> <TD>-50</TD> <TD>1350</TD> <TD>19500</TD> </TR> </TBODY> </TABLE> <P> </P> Sun, 15 Oct 2023 07:47:12 GMT https://community.qlik.com/t5/App-Development/Group-by/m-p/2128534#M91804 Mahamed_Qlik 2023-10-15T07:47:12Z