topic Re: Connecting three tables with single key in QlikView

Connecting three tables with single key

farheenayesha — Tue, 19 Nov 2013 08:17:19 GMT

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.

Re: Connecting three tables with single key

Tue, 19 Nov 2013 08:21:02 GMT

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

Re: Connecting three tables with single key

kaushiknsolanki — Tue, 19 Nov 2013 08:22:19 GMT

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

Re: Connecting three tables with single key

Anonymous — Tue, 19 Nov 2013 08:22:33 GMT

Ayesha

Why not simply concatenate the tables together.

Best Regards, Bill

Re: Connecting three tables with single key

hic — Tue, 19 Nov 2013 08:22:44 GMT

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

Re: Connecting three tables with single key

farheenayesha — Tue, 19 Nov 2013 09:40:24 GMT

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.

Re: Connecting three tables with single key

dmohanty — Tue, 19 Nov 2013 09:57:11 GMT

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.

Re: Connecting three tables with single key

farheenayesha — Wed, 20 Nov 2013 09:40:08 GMT

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.

Re: Connecting three tables with single key

jagan — Wed, 20 Nov 2013 10:06:02 GMT

Hi,

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

Regards,

Jagan.