topic Re: Table Relationship in QlikView

Table Relationship

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Table Relationship

Anil_Babu_Samineni — Tue, 18 Apr 2017 06:49:58 GMT

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.

Re: Table Relationship

marcus_malinow — Tue, 18 Apr 2017 12:32:57 GMT

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

Re: Table Relationship

Peter_Cammaert — Tue, 18 Apr 2017 12:50:04 GMT

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

Re: Table Relationship

Fri, 21 Apr 2017 06:06:23 GMT

Ok thanks for yours answers 🙂

Re: Table Relationship

oknotsen — Fri, 21 Apr 2017 06:49:51 GMT

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 .