Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
I currently have this:
Item | Cost Company 1 | Cost Company 2 |
---|---|---|
Item 1 | 350 | |
Item 1 | 250 | |
Item 2 | 360 | |
Item 2 | 240 |
And would like this:
Item | Cost Company 1 | Cost Company 2 |
---|---|---|
Item 1 | 350 | 250 |
Item 2 | 360 | 240 |
Any help is greatly appreciated
Thanks
Im not too sure without looking at it...
Perhaps a simple concatenation would work better.
Could you post your file and let us take a look?
Looks like you concatenated your tables. Try using join instead. See http://community.qlik.com/thread/39177 for a bit more explanation on join, keep and concatenate.
Thanks for the fast response.
That looks like exactly the problem. From looking at the thread you suggested I think I need an Outer Join. How do I make this happen? In the Script?
Thanks
Do it in the script
Load Item
[Cost Company 1]
From csv1
LEFT JOIN
Load Item
[Cost Company 2]
From csv2
Or something like that...
Hi,
Thanks for this.
LEFT JOIN just keeps company 1 value.
I almost need a LEFT & RIGHT JOIN dont I!!
Im probably doing something wrong. Apologies
Im not too sure without looking at it...
Perhaps a simple concatenation would work better.
Could you post your file and let us take a look?
Sorry for the delay
I have been trying to anonomyse the data due to the highly confidential nature of the data but when i do it works! which would obviously be no use.
I had originally thought it might be something to do with the item descriptions i have but have drawn a blank
I will continue to try and upload an anonomysed version for you to see
Thanks