Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: match values of 2 columns

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"?

Community Browser