Discussion board where members can get started with QlikView.
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?
1). Associations creation in Qlikview:
Tables not having common key, then create a common key to make association between tables.
LOAD * Inline [
4, Han Solo
OrderID, CustomerID, Product, QTY
11234, 4, Fedora Hat, 1
12234, 2, Hair Brush, 1
13234, 3, Breath Mints, 10
14234, 1, Light Sabre, 1
LOAD *, CustomerID as CustID
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.
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.
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
please refer to the qlik help;