Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
yamananalytic
Creator II
Creator 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
petter
Partner - Champion III
Partner - Champion III

Rename the field ParentID in the Governate to just Governate.

yamananalytic
Creator II
Creator II
Author

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
Specialist
Specialist

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
Creator II
Creator II
Author

I see ...

OK i will try

Thanks..

andrespa
Specialist
Specialist

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

Cheers,

Andrés