Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

How to get the un matched records in qlikview front end?

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:

CustomerContractpositionpartcompany
1212101working12Bmw
1215101repaired13Skoda
1254102unused12Audy
1254103working13Bmw
1212105repaired41Skoda
1215106unused42Audy
1211107working12Bmw

Table2:

CustomerContractpositionpartcompanydate
1212101working12Bmw1/12/2011
1215101repaired13skoda2/12/2012
1254102unused12Audy4/11/2010
1254103working13Bmw3/6/2010
1212105repaired41skoda6/4/2009
1215106unused42Audy5/4/2008
1211107working12Bmw4/9/2012
1211108working12Bmw02/5/1/2013
12102107working43Audy11/3/1911
1205109repaired44bmw12/7/2011
1205107unused46skoda11/3/1911
1208109working47bmw11/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.

1 Reply
Highlighted
Honored Contributor II

Re: How to get the un matched records in qlikview front end?

Hi.

I guess table 2 always contains more records than table 1.

So you can build key field:

autonumberhash128(Customer, Contract, position, part, company) as recordkey

And then check and mark the records in table 2:

exists('recordkey', autonumberhash128(Customer, Contract, position, part, company)) as existsflag