Table Relationship

[#1]

Hello,

I am a new user of clikview and I would like to know how to add primary keys (id) to tables imported from "excel" and how to make ternary relations without having synthetic keys generated. Thanks in advance for your help 😃

Alexandre

[Anil_Babu_Samineni]

First of all, Welcome to the Qlik product and the pronunciation is QLIKVIEW not clickview.

Primary key will form when we have same field on your Data source. So, you may make one same field in Qlik. So, Then check in Ctrl + T and then see whether the data model is assigned to the primary key or not that means associate to each other.

[marcus_malinow]

Hi Alexandre,

welcome to the community!

To make life easier for those of us inclined to help, please post some sample data. This doesn't have to be production data, just something to illustrate what your source fields are, and how you might want your data to be linked.

Marcus

[Peter_Cammaert · Accepted solution]

If you're new to QlikView, here is a free tip that may save you hours of headscratching and grinding your teeth: forget everything you know about Relational DBs, their concepts and how they act or should act. The internal (associative) data model of a QlikView document may look similar but will act in such a different way that it is better to start with a blank slate than by trying to take analogies from RDBMS models and behavior.

For instance: a Primary Key is a foreign concept in QlikView. And while you may be able to create something that looks alike at first, nobody in the entire QlikView universe will assist you in keeping it that way.

Not that this lack of known concepts will hinder you in any way. You'll gain an inordinate amount of power and freedom. It's just that the controls are a bit different

[#5]

Ok thanks for yours answers 🙂

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .