Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to see unmatched records

i want those records who are not match each other

match records (itemid) = 1,3,4

unmatch records(itemid) = 2,5,6,79

i want to see these records(2,5,6,7,9) in



Table 1
table1_idtable1_itemidtable1_name/desc
11fksdf
21fksdf
32fksdf
42fksdf
53fksdf
64fksdf
75fksdf
Table 2
table2_idtable2_itemidtable2_name/desc
11fksdf
26fksdf
31fksdf
44fksdf
57fksdf
63fksdf
79fksdf


or

is it possible to make "unmatch" and "match" fields

ciriteria

Both
Match

Unmatch

when i clik both it show all records(1,2,3,4,5,6,7,9)

when i click on Match records it will show only those records whose item id are in both table(,1,2,4)

when i click on unmatch then it will show only those records whose itme id are not match in both tables i.e(2,5,6,7,9)

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example of what you asked for

check the list boxes to see

the expression which check what kind of item is each item

View solution in original post

4 Replies
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example of what you asked for

check the list boxes to see

the expression which check what kind of item is each item

Not applicable
Author

thank you

can you tell me how we can make these two table

matched

unmatched

in scripting level

lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example doing the logic the script

Not applicable
Author

Hi, i think this is other way to get the same.