Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Relation between tables .

Hi guys,

Firstly i would like to thank you for the help you have given to me here is this community.


There is an issue i want to discuss it with you:

1- I have three table (person and names and ages) in person table there are two fields which are name and age and the two other tables are linked to Person table using Person ID.

2-In Data Model Viewer in Field section if i choose the first table (Person) it will show me all field of this table (name and age) what i want to do is if i choose name it lists all name inside table name at a specific Person ID .


I hope i could explained clearly .

rwunderlich

swuehl

stalwar1

omarbensalem

11 Replies
OmarBenSalem

Not really; could u explain with some sample values please?
Maybe 3 lines of each table, and when you select name from table person, what do u want to show?

neha_shirsath
Specialist
Specialist

Not understood what exactly you want to achieve, in Data Model viewer what exactly you want to see?

Anonymous
Not applicable
Author

i changed the last example

Here i have two tables :

1-Organization :

11.png

2-Names :

22.png

What i want to do inside Data Model Viewer is:

If i select the Organization table all its columns will be shown which are (companynames,schoolnames,bakreynames)

after that if i select schoolnames all records from Names table which have ID = (2) will be shown which are (alsaade ,poin)

omarbensalem

OmarBenSalem

Fist of all, the 2 table should be linked;

rename ID as PersonID

second of all, u can't see that in the data model viewer; but rather create a table in the sheet, and put all the dimensions measures u want to show; create some filter and u'll have what u're looking for

neha_shirsath
Specialist
Specialist

I think this is not possible, as data model viewer is just to show the linking of tables not what the individual fields data details.

Anonymous
Not applicable
Author

Sorry : there was a mistake in my previous comment.

i changed the last example

Here i have two tables :

1-Organization :

11.png

2-Names :

22.png

What i want to do inside Data Model Viewer is:

If i select the Organization table all its columns will be shown which are (companynames,schoolnames,bakreynames)

after that if i select schoolnames all records from Names table which have ID = (2) will be shown which are (alsaade ,poin)

neha_shirsath
Specialist
Specialist

What is the linking field for Organization and Names table?

First understand the primary key between both tables.

Anonymous
Not applicable
Author

Dear .

Simply i want to view details for the specific field (which are exists in another table ) inside data viewer when i drag and drop that field.

neha_shirsath
Specialist
Specialist

This is not possible in data model viewer. You can try this on front end.