link tables

Anonymous — Tue, 22 Jul 2014 17:31:25 GMT

How to create link Tables in Qlikview ? please provide me examples

Re: link tables

Anonymous — Tue, 22 Jul 2014 17:32:41 GMT

If you have same names from different tables link will happen automatically.

Re: link tables

maxgro — Tue, 22 Jul 2014 18:22:18 GMT

Creacion Link Table

Re: link tables

its_anandrjs — Tue, 22 Jul 2014 18:51:16 GMT

Hi Chandini,

Check this small example of the Link tables which is small example please copy and paste this example for understand how link table works in this sample three tables used Sales, Budget and Customer master details.

Sales:

LOAD Year&'_'&Month&'_'&[Customer Number] as Key,[Sale Amt],Year,Month,[Customer Number];

LOAD * INLINE [

Year, Month, Customer Number, Sale Amt

2013, 4, A, 15874

2014, 5, B, 12569

];

Budget:

LOAD Year&'_'&Month&'_'&[Customer Number] as Key,[Budget Amt],Year,Month,[Customer Number];

LOAD * INLINE [

Year, Month, Customer Number, Budget Amt

2013, 4, A, 45000

2014, 5, B, 46000

];

Customer:

Load * Inline

[

Customer NO,Customer Name

A,Kim

B,Saun

];

LinkTable:

LOAD Key,Year as YEAR,Month as MONTH,[Customer Number] as [Customer NO] Resident Sales;

LOAD Key,Year as YEAR,Month as MONTH,[Customer Number] as [Customer NO] Resident Budget;

DROP Fields Year,Month;

SalesTable:

LOAD Key,[Sale Amt] Resident Sales;

DROP Table Sales;

BudgetTable:

LOAD Key,[Budget Amt] Resident Budget;

DROP Table Budget;

Re: link tables

Anonymous — Thu, 18 Sep 2014 09:13:31 GMT

Hi Anand..

Its help full for me..............

Thanks & Regards,

Chandini.G

topic Re: link tables in QlikView

link tables

Re: link tables

Re: link tables

Re: link tables

Re: link tables