topic Re: Relation between tables in QlikView

Relation between tables

Mon, 09 Dec 2013 11:50:51 GMT

Dear All ,

I am very new to Qlikview and BI . I am very excited to work on this emerging tool.

I have got a kind of an assignment from my team lead.

I have 3 tables . A , B and C table .

Relationship between A to B is One to Many .

And relation between B to C table is Many to One .

What would be the relation between A and C table in Qlikview ?

Also , i want to understand how to find the relationships would be in different scenarios as well . So Any document on identifying relationship among various tables in the Qlikview would be very helpful .

Regards,

Lakshman .

Re: Relation between tables

Mon, 09 Dec 2013 12:57:39 GMT

I Guess the relationship between A and C table should be 1:1 . Can anyone please confirm this ?

Thanks in Advance .

Lakshman .

Re: Relation between tables

Anonymous — Mon, 09 Dec 2013 13:05:35 GMT

What you have is the correct way of linking, considering B as your FACT table and A and C as your dimension tables.

Re: Relation between tables

Mon, 09 Dec 2013 13:17:48 GMT

Thank U so much for the reply Aadil M .

Primarily i want to know about the relation between A and C table . Is it one-to-one or one-to-many or many-to-many . Could u please help me in that as well .

Re: Relation between tables

Anonymous — Mon, 09 Dec 2013 13:23:58 GMT

Many-to-many

Re: Relation between tables

Mon, 09 Dec 2013 13:25:39 GMT

it depends on what your data is. You cant say exactly what it is.

Example:

A = Students

B = Electives

C = Classroom

One student can be assigned to many electives -

One Classroom can have many electives

This is a really bad example but i hope you get the picture

So you should determine should one student only be assigned to one classroom? Then its 1 to 1

Re: Relation between tables

Mon, 09 Dec 2013 15:00:48 GMT

Thank U so much for the reply Micheal and Thomas . .

These are the two option what i felt would be correct . And I am confusion state still .

Lets say ,

A= Customer table (I have customer information)

B= Intermediate table (Link/Junction table)

C= Account table (I have accounts , Sales information)

for the same scenario , where A-B is one to many and B-C is many to one .

Can u please tell me what would be the relation between Customer and Accounts and Why , so that i will be very clear and close this question ?

Thanks in advance ,

Lakshman.

Re: Relation between tables

Mon, 09 Dec 2013 15:04:42 GMT

I would say one to one. One customer can only have one account (thats the most common) - So i cant see why it should be a many to many. And i cant see why it should be 1 to many. Cause it makes no sense that a customer is a dublet. (created twice)

So if your system is "common as in normal" then one customer can only have one account and therefore 1to1

Re: Relation between tables

Mon, 09 Dec 2013 15:13:02 GMT

It depends on your data.

One customer could have many Accounts.

Re: Relation between tables

Mon, 09 Dec 2013 15:30:50 GMT

Thanks for the reply Parminder .

Re: Relation between tables

Mon, 09 Dec 2013 15:31:29 GMT

Thanks for Clarifying Thomas ..