Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

match values of 2 columns

Hi, I have 2 columns called 'itemnum', from different tables, that contain common values. When I made this column name primary key, and created a tablebox, I discovered that the values do not match but instead they just appear individually in the table, creating duplicate values in the itemnum column. How do I match the same values? Because I also want to display other data relating to the itemnum and there are null columns all over as the itemnum values repeat, displaying only data for the the related columns that appear in their respective table/data source. Thanks.

1 Reply
Not applicable
Author

can you attach the app please. It shouldn't display duplicate values.. Can you look at the table viewer to see if those 2 tables are joined by "itemnum"?