Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yamananalytic
Contributor II

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

Tags (1)
11 Replies
OmarBenSalem
Esteemed Contributor

Re: Relation between tables .

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
Valued Contributor

Re: Relation between tables .

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

yamananalytic
Contributor II

Re: Relation between tables .

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
Esteemed Contributor

Re: Relation between tables .

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
Valued Contributor

Re: Relation between tables .

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.

yamananalytic
Contributor II

Re: Relation between tables .

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
Valued Contributor

Re: Relation between tables .

What is the linking field for Organization and Names table?

First understand the primary key between both tables.

yamananalytic
Contributor II

Re: Relation between tables .

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
Valued Contributor

Re: Relation between tables .

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

Community Browser