Qlik Community

Ask a Question

New to Qlik Sense

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

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

Table relationship

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 

Capture.PNG

 

q11hhg_0-1614249830230.png

 

Labels (2)
1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

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;

 

View solution in original post

1 Reply
micheledenardi
Specialist II
Specialist II

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;

 

View solution in original post