Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

amigo007
New Contributor III

Unmatching records without modifying the loading script

I have 2 tables joined with a field called ID, I have e.g. a table A and table B as shown below. How can I list in a straight table the non-matching records, i.e. records with ID 5, 6 and 7 from table B?

Ideally, I don't want to make the unmacthing/changes to my loading scripts. Is there any kind of expression to make this listing inside a table object?

Table A:

IDNameCityCountry
1JohnLondonEngland
2DavidParisFrance
3JennyBerlinGermany
4MarkRomeItaly

Table B:

IDCost
11000
21500
33000
4500
56000
6

7000

75500
Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Unmatching records without modifying the loading script

If you can find a candidate key in table A, assume field Name here, you could try like:

Calc dimension: If( Isnull(Name), ID)

Exp: Sum(Cost)

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Unmatching records without modifying the loading script

If you can find a candidate key in table A, assume field Name here, you could try like:

Calc dimension: If( Isnull(Name), ID)

Exp: Sum(Cost)

View solution in original post

shiveshsingh
Honored Contributor

Re: Unmatching records without modifying the loading script

Yes, you can use calculated dimension as =if(IsNull(Name),ID)

and tick Suppress when Value Is Null in chart properties.

amigo007
New Contributor III

Re: Unmatching records without modifying the loading script

Works just fine, thanks!