Re:association

t_vijay_qlik — Wed, 25 Nov 2020 16:16:04 GMT

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

Re:association

kfoudhaily — Sat, 28 Jul 2018 20:19:28 GMT

Hello,

please refer to the qlik help;

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

regards,

Re:association

BalaBhaskar_Qlik — Sun, 29 Jul 2018 13:16:57 GMT

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.

topic Re:association in QlikView

Re:association

Re:association

Re:association