https://community.qlik.com/t5/App-Development/Get-two-specific-values-from-different-tables/m-p/1817405#M66952 <P>Hey!</P><P>I'm trying to develop a chart for a dashboard. I have two different tables with the same common key (but that key has different names in the different tables (wallet &amp; bonus_receiver)).</P><P>Basically in one table, the PK is "wallet" and in the second one, it is "bonus_receiver" (also a wallet id). In both tables, there are multiple lines with transactions for those wallets with the amounts. I can sum the amount of all transactions and aggregate it per wallet and per bonus_receiver.</P><P>I want to do this subtraction: sum(amount per wallet) - sum(amount per bonusi_receiver). All this per specific wallet in order to have the difference between both tables per wallet. As I'm trying to do this in a chart, I want the x axis (dimension) to be the wallet id (that can be the wallet field as well as the bonusi_receiver once they have the same values) and the measure I want that to be the substraction.</P><P>How can I do it? I believe I need to pick the wallet field in the first table and search that value in the second table but when I try it runs out of time.</P><P>I'm attaching a print of the two different tables and the 4 fields I'm talking about so you can understand. Thanks!</P> Wed, 23 Jun 2021 14:28:54 GMT tomasfsa 2021-06-23T14:28:54Z https://community.qlik.com/t5/App-Development/Get-two-specific-values-from-different-tables/m-p/1817405#M66952 <P>Hey!</P><P>I'm trying to develop a chart for a dashboard. I have two different tables with the same common key (but that key has different names in the different tables (wallet &amp; bonus_receiver)).</P><P>Basically in one table, the PK is "wallet" and in the second one, it is "bonus_receiver" (also a wallet id). In both tables, there are multiple lines with transactions for those wallets with the amounts. I can sum the amount of all transactions and aggregate it per wallet and per bonus_receiver.</P><P>I want to do this subtraction: sum(amount per wallet) - sum(amount per bonusi_receiver). All this per specific wallet in order to have the difference between both tables per wallet. As I'm trying to do this in a chart, I want the x axis (dimension) to be the wallet id (that can be the wallet field as well as the bonusi_receiver once they have the same values) and the measure I want that to be the substraction.</P><P>How can I do it? I believe I need to pick the wallet field in the first table and search that value in the second table but when I try it runs out of time.</P><P>I'm attaching a print of the two different tables and the 4 fields I'm talking about so you can understand. Thanks!</P> Wed, 23 Jun 2021 14:28:54 GMT https://community.qlik.com/t5/App-Development/Get-two-specific-values-from-different-tables/m-p/1817405#M66952 tomasfsa 2021-06-23T14:28:54Z https://community.qlik.com/t5/App-Development/Get-two-specific-values-from-different-tables/m-p/1817524#M66969 <P>Hi,</P><P>I think doing join between the two tables using wallet and bonus receiver will resolve the issue.</P><P>With that the new table will have wallet, sum(amount per wallet), sum(amount per bonus receiver) which makes the subtraction easy.</P><P>Hope this will help. Thanks!</P> Thu, 24 Jun 2021 07:28:10 GMT https://community.qlik.com/t5/App-Development/Get-two-specific-values-from-different-tables/m-p/1817524#M66969 meghana2006 2021-06-24T07:28:10Z https://community.qlik.com/t5/App-Development/Get-two-specific-values-from-different-tables/m-p/1817706#M66985 <P>But I was trying to solve this without changing anything from the backend script. Only from an expression in the chart functionalities. Any idea?</P><P>Thanks in advance</P> Thu, 24 Jun 2021 18:45:36 GMT https://community.qlik.com/t5/App-Development/Get-two-specific-values-from-different-tables/m-p/1817706#M66985 tomasfsa 2021-06-24T18:45:36Z