Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
a_perr
New Contributor

Display IDs from a table A that don't have an equivalent in table B

Hello all,

I have 2 tables A and B, linked by a third "join" table, under the following pattern:

TableA ("ID_A": A1, A2, ...)

TableJoin("ID_A":A1,           A2,          ...

                     "ID_B":B127,      B213,      ...)

TableB ("ID_B": B1, B2, ...)

 

My goal is to create two tables, one from TableA displaying all the ID_A lines that don't have an ID_B associated in TableB, and vice versa.

 

Do you have any tip as to how to do that?

 

If I had a TableC with ID_A keys (no TableJoin), would the process be similar?

 

1 Reply
Partner
Partner

Re: Display IDs from a table A that don't have an equivalent in table B

Lets say you have this datamodel

SET NullInterpret  = '';  //To get correct null() values from inline table
A:
load * INLINE [
ID_A
A1
A2
A4
];

B:
load * INLINE [
ID_B
B1
B3
B4
];


LINK:
LOAD * INLINE [
ID_A, ID_B
A1, B1
A2, 
  , B4
A4, B4
];

Then you can use these expression to fetch how many IDs are without a link.

=COUNT({-$<ID_B = {"*"}>}ID_A)

=COUNT({-$<ID_A= {"*"}>}ID_B )

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes