Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

merging table fields

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:

ItemCost Company 1Cost Company 2
Item 1350
Item 1250
Item 2360
Item 2240

And would like this:

ItemCost Company 1Cost Company 2
Item 1350250
Item 2360240

Any help is greatly appreciated

Thanks

1 Solution

Accepted Solutions
Not applicable

Re: merging table fields

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?

6 Replies

Re: merging table fields

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.


talk is cheap, supply exceeds demand
Not applicable

Re: merging table fields

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

Not applicable

Re: merging table fields

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...

Not applicable

Re: merging table fields

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

Not applicable

Re: merging table fields

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?

Not applicable

Re: merging table fields

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

Community Browser