Connecting three tables with single key

[farheenayesha]

Hi,

I have 3 tables ( shown below) . I want to connect these 3 tables with one key ID that is opportunity Id. Can someone suggest me how can i connect these tables? If i connect with opportunity ID am getting loop.

I have used linktable because i have lot of fields in common between these two tables. Can anybody suggest me other method(without linktable) to connect these two tables.

[#2]

You want to connect 2 tables (Opportunity & Quote_line) or all 3 tables?

[kaushiknsolanki]

Hi,

    Have a look at the attached application, which is a example of link table.

    Also see the below link.

    http://dailyqv.blogspot.in/2012/12/link-tables.html

Regards,

Kaushik Solanki

[Anonymous]

Ayesha

Why not simply concatenate the tables together.

Best Regards,     Bill

[hic]

I would skip the link table and concatenate the two fact tables.

If you search for "concatenated fact table" on QlikCommunity, you will find many good posts about pro:s and con:s.

HIC

[farheenayesha]

Thanks everyone. I'll try to concatenate the tables as suggested by Bill & Henric and i will get back to you guys if i get any doubts.

Thanks Kaushik for providing me the link and example file.

[dmohanty]

Ayesha,

Best practice is to CONCATENATE the two Fact Tables rather than using Link Table.

Please try to Concatenate both.

Also refer the attached document, it might be helpful for you.

[farheenayesha]

Thanks Mohanty..I concatnated both the tables but am getting slightly diffferent values compared to excel computing. Can anyone tell me, why i am getting this difference. Please find Qlikview analysis on right and excel analysis on left in the below figure.

[jagan]

Hi,

Can you attach some sample data and qlikview file, it helps in understanding.

Regards,

Jagan.