Conditional sum between 2 tables in qlik sense.

Van_card601 — Mon, 22 Apr 2024 23:01:49 GMT

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!

Re: Conditional sum between 2 tables in qlik sense.

BrunPierre — Tue, 23 Apr 2024 08:58:19 GMT

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;

topic Conditional sum between 2 tables in qlik sense. in Management & Governance

Conditional sum between 2 tables in qlik sense.

Re: Conditional sum between 2 tables in qlik sense.