Conditional sum between 2 tables in qlik sense.

[Van_card601]

Hi!

I have a dashboard with 2 excel tables in the contents (Table 1 and Table 2). I need to do some KPIs, summarizing, values from table 2, but just the ones that belongs to a list of people in Table 1. The field that I need to use to compare between 2 tables is the "key" between the tables. Is there any way or formula I can use to do that conditional exercise. 

Is it clear? Can maybe I build a new table from the 2 existing ones?

Thank you! 

[BrunPierre]

Hi, one approach is with Exists():

Tabe1:
LOAD key as KeyToCheck
From abc;

Table2:
LOAD Key,
Value,
...
From xyz
Where Exists(KeyToCheck,Key); /*Checks if the "Key" in Table2 exists in "KeyToCheck" from Table1*/

DROP Table Tabe1;