Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yamananalytic
Contributor II

Relations between tables

Hi Guys,

I have these tables :

12.png

these two tables have one record in side each table,the value of ParentID in Governorate table is the same value of Governorate field inside Bakaries table so i want to define the relation between them and draw line between associated fields.

swuehl

stalwar1

rwunderlich

omarbensalem

5 Replies
MVP
MVP

Re: Relations between tables

Rename the field ParentID in the Governate to just Governate.

yamananalytic
Contributor II

Re: Relations between tables

Yes you are right Mr. Petter

but the tables in my case  are hierarchy in other word if i have another table called Hier and inside this table there is a field called Governorate but the parent

of this table is Governorate field inside Governorate table not Governorate field  inside bakaries table.

I hope i could explain clearly.

petter-s

andrespa
Valued Contributor

Re: Relations between tables

You need to give different names if the fields are refering to something different. That been said, you could name the Governorate field between Governorate and Bakaries tables something like key_governorate.

Hope it helps,

Andrés

yamananalytic
Contributor II

Re: Relations between tables

I see ...

OK i will try

Thanks..

andrespa
Valued Contributor

Re: Relations between tables

Hi, if that answered your question, please mark as correct/helpul to close the trend and help other in the future.

Cheers,

Andrés