Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
t_vijay_qlik
New Contributor III

Re:association

hi all,

What is association in qlik in  tables?

What are the performance measures to be followed?

When ever we load data into qlikview it automatically performs all the associatons?

Can any one explain about the concept of synthetic key?

thanks

vijay kumr

1 Solution

Accepted Solutions
Highlighted
balabhaskarqlik
Honored Contributor

Re:association

1). Associations creation in Qlikview:

Tables not having common key, then create a common key to make association between tables.

Ex:

Customer:

LOAD * Inline [

CustID, CustomerName

1, Luke

2, Leia

3, Chewbacca

4, Han Solo

];

Orders:

LOAD * Inline [

OrderID, CustomerID, Product, QTY

11234, 4, Fedora Hat, 1

12234, 2, Hair Brush, 1

13234, 3, Breath Mints, 10

14234, 1, Light Sabre, 1

];

NewOrder:

LOAD *, CustomerID as CustID

RESIDENT Orders;

DROP TABLE Orders;

Load data, Now Customer and NewOrder table having an auto Assosiation with CustId column.

2). Auto Associations between tables in qlikview:

Field names must be exactly the same for auto-association links between tables. 

Ex:

Customer:

Load

     CustId,

     CustName

From Customer.xlsx;

Orders:

Load

     OrderId,

     CustId,

     OrderDetails

From Order.xlsx;

Load data, Now both tables having common key as CustId, so it'll form Auto Association between tables.

3. Synthetic Keys in Qlikview:

More fields with common names form Synthetic keys and a new Synthetic table with common names.

Ex:

Customer:

Load

     CustId,

     OrderId

     CustName

From Customer.xlsx;

Orders:

Load

     OrderId,

     CustId,

     OrderDetails

From Order.xlsx;

Load Data, Now both tables are having two common names as CustId,OrderId, so it creates an Extra table with common names. Clear this issue with rename, qualify, unqualify options.

View solution in original post

2 Replies
Highlighted
kfoudhaily
Contributor III

Re:association

Hello,

please refer to the qlik help;

https://help.qlik.com/en-US/

regards,

Highlighted
balabhaskarqlik
Honored Contributor

Re:association

1). Associations creation in Qlikview:

Tables not having common key, then create a common key to make association between tables.

Ex:

Customer:

LOAD * Inline [

CustID, CustomerName

1, Luke

2, Leia

3, Chewbacca

4, Han Solo

];

Orders:

LOAD * Inline [

OrderID, CustomerID, Product, QTY

11234, 4, Fedora Hat, 1

12234, 2, Hair Brush, 1

13234, 3, Breath Mints, 10

14234, 1, Light Sabre, 1

];

NewOrder:

LOAD *, CustomerID as CustID

RESIDENT Orders;

DROP TABLE Orders;

Load data, Now Customer and NewOrder table having an auto Assosiation with CustId column.

2). Auto Associations between tables in qlikview:

Field names must be exactly the same for auto-association links between tables. 

Ex:

Customer:

Load

     CustId,

     CustName

From Customer.xlsx;

Orders:

Load

     OrderId,

     CustId,

     OrderDetails

From Order.xlsx;

Load data, Now both tables having common key as CustId, so it'll form Auto Association between tables.

3. Synthetic Keys in Qlikview:

More fields with common names form Synthetic keys and a new Synthetic table with common names.

Ex:

Customer:

Load

     CustId,

     OrderId

     CustName

From Customer.xlsx;

Orders:

Load

     OrderId,

     CustId,

     OrderDetails

From Order.xlsx;

Load Data, Now both tables are having two common names as CustId,OrderId, so it creates an Extra table with common names. Clear this issue with rename, qualify, unqualify options.

View solution in original post