topic Re: Unmatching records without modifying the loading script in QlikView

Unmatching records without modifying the loading script

amigo007 — Wed, 25 Nov 2020 16:16:04 GMT

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:

ID	Name	City	Country
1	John	London	England
2	David	Paris	France
3	Jenny	Berlin	Germany
4	Mark	Rome	Italy

Table B:

ID	Cost
1	1000
2	1500
3	3000
4	500
5	6000
6	7000
7	5500

Re: Unmatching records without modifying the loading script

tresB — Mon, 05 Mar 2018 11:53:06 GMT

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)

Re: Unmatching records without modifying the loading script

shiveshsingh — Mon, 05 Mar 2018 12:38:29 GMT

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

and tick Suppress when Value Is Null in chart properties.

Re: Unmatching records without modifying the loading script

amigo007 — Mon, 05 Mar 2018 13:55:13 GMT

Works just fine, thanks!