Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to create link tables same as shown in the image below.H ow can I do in script plz help.
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)
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)
can you please share the script.
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
];
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?
It's a little fuzzy can you elaborate more please? What do you mean with "using the table from the data model. "