Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to build ERD with keys table?


How to build ERD with keys table?

Can i have links or explanations?

I got lost !!!

1 Reply

Hi Alon,

I assume you want to create the datamodel? Do you have a screen shot of your current ERD (table)? That would help.

The way it works in Qlikview is, you may need to rename the key field that you want to join with another table. Once the key fields are the same, it will automatically create the join (It's not the same as in SQL, which you just drag a line from one table to another - you need to do it via Qlikview Script).

For example:

Table Employee has 2 fields:

EmpID, EmpName

Table Department has 3 fields: (Just for our test purpose, ignore how "Emp Number" is created in Department table )

Emp Number, DepartmentID, DepartmentName

To join the Employee and Department via EmpID or Emp Number as the key, you need to rename either one to match one another. So either you need to rename Emp Number to become EmpID (or vice Versa).

     EmpID as [Emp Number]


     [Emp Number] as EmpID

Hope this helps,

Best regards,