Relation between tables

[#1]

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 .

[#2]

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

Thanks in Advance .

Lakshman .

[Anonymous]

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

[#4]

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 .

[Anonymous]

Many-to-many

[#6]

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

[#7]

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.

[#8 · Accepted solution]

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

[#9]

It depends on your data.

One customer could have many Accounts.

[#10]

Thanks for the reply Parminder .