Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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