Table relationship

[q11hhg]

Hi there,

I just started to use Qliksesen. I am not sure if the relationship like the attached first screenshot will be ok ?

I only want to disconnect the relationship between Events and Orders but keep the relationship only on the  Region table like the second screenshot.

How can I do that 

[micheledenardi · Accepted solution]

On Qlik Associative model, If two fields have the same name in two (or more) different tables (i.e. a relationship), they will be considered as Keys.

In order to create your data model you need to create two new field which create the relation between Events->Region and Region->Order, like this:

Event:
Load
   Country,
   Country as CountryEvents,
   CustomerID,
   Date,
   EventType,
   TotalEvent
From YOURDATASOURCE;

Orders:
Load
   Country,
   Country as CountryOrder,
   OrderID,
   OrderDate,
   Currency,
   Rate,
   Order_Customer_ID,
   Order Value Euro
From YOURDATASOURCE;

Region:
Load
    Country,
    Country as CountryEvents,
    Country as CountryOrder
From YOURDATASOURCE;