How get the un matched records in qlikview front end?

[#1]

Hi All

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

Thank you.

[maxgro]

a bit difficult to guess what are unmatched records

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null

if you can clarify..........,thanks

[#3]

Can you attach a sample of your case if possible. It will be easy to address it.

Thanks

[#4]

Hi Ajay

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.

[#5]

I kinda understand.

I created a Flag on the back-end with values True and False. True will give you values available in both tables and False only those in the second table(basically missing in Table 1).

Hope this helps

Thanks

AJ

[#6]

If you don"t mine can u explain me brifely how you did ,which expressions you used there and what are the transformations you made in load script.

[anbu1984]

Table1:

Load position,count(position) as cnt Inline [

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 ]

Group  by position;

Join(Table1)

Table2:

Load position ,count(position) as cnt1 Inline [

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  ]

Group  by position;

Final:

Load position, cnt as [Total contract in table1],cnt1 as [Total contract in table2], Fabs(cnt-cnt1) as Differenct Resident Table1;

[#8]

Hi anbu cheliyan

thank you for replay ...but the solution you provided is not my objective. my objective is i have to shoe the records those are excess in two tables as position wise

let us take

Position:     Total contract in table1               Total contract in table2        difference

  working              3                                                  6                                 3[i have to show these 3 records from table2]]

unused                4                                                  3                                 1   [i have to show this one record from table1]

Hope you got it.

thank you once again.

[anbu1984]

Try this

Table1:

Load 'T1' as Table ,*  Inline [

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 ];

Join(Table1)

Table2:

Load 'T2' as Table1 ,* Inline [

Customer,Contract,position1,part1,company1,date1

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  ];

NoConcatenate

Final:

Load * Resident Table1 Where IsNull(Table) Or IsNull(Table1) ;

Drop table Table1;

[#10]

My bad. I forgot to attach the sample file. Here it is. Please look at it and let me know if you have any questions.

Thanks

AJ