topic Re: Link Table in QlikView

Link Table

Jacob — Sat, 16 Nov 2024 04:50:39 GMT

Hi All,

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

Re: Link Table

sergio0592 — Sun, 06 Jan 2019 22:19:53 GMT

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)

Re: Link Table

Jacob — Mon, 07 Jan 2019 05:50:28 GMT

can you please share the script.

Re: Link Table

sergio0592 — Mon, 07 Jan 2019 07:50:23 GMT

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
];

Re: Link Table

Jacob — Mon, 07 Jan 2019 10:05:39 GMT

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

Re: Link Table

sergio0592 — Mon, 07 Jan 2019 17:30:09 GMT

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