Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Jacob
New Contributor II

Link Table

Hi All,

I want to create link tables same as shown in the image below.H ow can I do in script plz help.

Capture1.PNG

Labels (4)
1 Solution

Accepted Solutions
sergio0592
Valued Contributor II

Re: Link Table

Hi,

Qlikview links table on field with the same name. So, use load inline in the load statement and you will get yours link table in the the table viewer (ctrl+T)

 

P1.jpg

5 Replies
sergio0592
Valued Contributor II

Re: Link Table

Hi,

Qlikview links table on field with the same name. So, use load inline in the load statement and you will get yours link table in the the table viewer (ctrl+T)

 

P1.jpg

Jacob
New Contributor II

Re: Link Table

can you please share the script.

sergio0592
Valued Contributor II

Re: Link Table

Just use load inline in your load statement

SECTION_ACCESS:
LOAD *

INLINE [
NTNAME, ACCESS, USERID,
Username1,ADMIN,1
Username2,USER,2
Username3,ADMIN,3
Username4,USER,4]
;

USER_RIGHTS_LINK:
LOAD *
INLINE [
USERID,S.EmployeeID,E.EmployeeID
A,1,1
A,2,2
A,3,3
B,1,3
B,1,3
C,1,no
C,3,no
D,1,1
D,2,no
D,3,3
];

EMPLOYEE:
LOAD *
INLINE [
E.EmployeeID,Adress,Phone
1,Road,0899
2,Street,89668
3,City,68766
];

SALES:
LOAD *
INLINE [
S.EmployeeID, Value, Quantity
1,2500
2,1500
3,3500
];

Jacob
New Contributor II

Re: Link Table

Hi

I have one question. I want to implement the same scenario in my project using the table from the data model. How can do?

sergio0592
Valued Contributor II

Re: Link Table

It's a little fuzzy can you elaborate more please? What do you mean with "using the table from the data model. "