Joins giving incorrect data and Concatenate giving filtering issues

[sujeetsingh]

Hi Everybody,,,

This is my first query regarding joins .

I have two tables Table1 and Table2 with primary key EmpleeeID.

Table1 has a lots of details regarding name,company,date ...and alot.

Table2 has primary key EmployeeID and two distinct fields.

now when i join them (with all joins inner,left outer,,,all tried) the data is alittle bit more .

On the other hand when i concatenat them then i get all data correct but the filter which are using the fields from Table1 then thir ic no data display on charts dealing with fields taken from Table2.

Plz do reply frends and of course seniors..

Thanks sujeet

[#2]

You probably don't need to use the join statement.

Check the table structure in Qlikview (use CTRL-T) and check if the keys have exactly the same name (or make them identical).

[#3]

Henric Cronstom wrote a very helpful paper on various joins, explicit and implicit, that helped me very much in understanding how Qlikview joins tables.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join#comment-5698

[sujeetsingh]

Walter the keys are same and correct..

[sujeetsingh]

Thanks kevin for your reply but i too have reffered this blog.

[kamalqlik]

Hi Sujeet,

   This is because there may be some duplicacy in data because Primary key is not returning the unique data.

Just make a composite key for getting the correct data.

Or post your table.

I will try to that.

Ragards

Kamal

[sujeetsingh]

Thanks for your reply Kamal but its not so...is the id are same then the column of that joined table should be in the output.

[kamalqlik]

Hi Sujeet,

Can you give me a brief description about your table.

Hi dont use join try simple association as qlikview work.

Or please post the application.

There may be a case that your both table have different Emplooyee Id so you are not getting the results

Regards

Kamal

[sujeetsingh]

Thanks for your reply.

Actually why it is so that when i am using concatenation then results are appprox. but the filters do not have access on concatenated table graphs.