How to get the un matched records?

[#1]

Hi All   Can any one help me to get the un matched records in qlikview front end? 

This is my data and i need the difference value records from each table according to position

Table1:

Customer	Contract	position	part	company
1212	101	working	12	Bmw
1215	101	repaired	13	Skoda
1254	102	unused	12	Audy
1254	103	working	13	Bmw
1212	105	repaired	41	Skoda
1215	106	unused	42	Audy
1211	107	working	12	Bmw

Table2:

Customer	Contract	position	part	company	date
1212	101	working	12	Bmw	1/12/2011
1215	101	repaired	13	skoda	2/12/2012
1254	102	unused	12	Audy	4/11/2010
1254	103	working	13	Bmw	3/6/2010
1212	105	repaired	41	skoda	6/4/2009
1215	106	unused	42	Audy	5/4/2008
1211	107	working	12	Bmw	4/9/2012
1211	108	working	12	Bmw	02/5/1/2013
12102	107	working	43	Audy	11/3/1911
1205	109	repaired	44	bmw	12/7/2011
1205	107	unused	46	skoda	11/3/1911
1208	109	working	47	bmw	11/4/1202

Here  is my end what i have upto know

  Position:     Total contract in table1               Total contract in table2        difference

  working              3                                                  6                                 3

here difference is 3 , now i need those 3 different records from table 2.

Hope you understand Please Provide me some help to over come this.   Thank you.

[#2]

i need to compare those to tables.

[#3]

I think you still be able. You told, that smaller is subset of bigger. Do

additional field with values for example 1 or 2. 1 means that row was only

in 1 table. 2 - row was in borh tables. Rows with 1 are difference you are

looking for.

Good Luck

Darek

17-05-2014 13:05 użytkownik "johnDawson" <qcwebmaster@qlik.com> napisał:

Qlik Community <http://community.qlik.com/> How to get the un

matched records?

reply from johnDawson<http://community.qlik.com/people/johnDawson?et=watches.email.thread>in *New

to QlikView* - View the full discussion<http://community.qlik.com/message/530326?et=watches.email.thread#530326>

[#4]

I tried Dariusz i got all common and uncommon but i am unable to get this scenario

[#5]

let's say, that you added field named new_field, with values 1 for rows existing in both old tables and 0 for rows existing only in bigger table.

With expression:

count({<new_field={0}>}contracts)

you should have number of contracts you need.

[#6]

If you have now only one table with additional field which marks common and

uncomonn rows, use set analysis in your expression:

Count({<newfield={1}>} newfield)

This will give number of those rows which you marked as 1.

17-05-2014 13:49 użytkownik "johnDawson" <qcwebmaster@qlik.com> napisał:

Qlik Community <http://community.qlik.com/> How to get the un

matched records?

reply from johnDawson<http://community.qlik.com/people/johnDawson?et=watches.email.thread>in *New

to QlikView* - View the full discussion<http://community.qlik.com/message/530332?et=watches.email.thread#530332>