Im fairly new to Qlikview so I imagine this is a very simple question.
I have loaded two worksheets from a spreadsheet into QV which display the same data but for two seperate organisations. One of the fields on each worksheet is a number for the cost of 21 different items but the heading for this is different on each worksheet e.g "Cost company 1" & "Cost company 2".
When I try to create a table in QV to show these items and their costs for each company it duplicates the item rows. how do I get one row for each item with the two costs shown next to it?