Discussion Board for collaboration on QlikView Scripting.
I have table A which is having column ID , Name,SupervisorID
ID Name SupervisorID
1 A 3
3 C 2
4 D 2
I want to show ID , Name, Supervisor Name , without using hierarchy load .
Go to Solution.
How about something like this ?
LOAD * INLINE [
ID, Name, SupervisorID
1, A, 3
3, C, 2
4, D, 2
ID as SupervisorID,
Name as SupervisorName
applymap('SuperMap',SupervisorID, null() ) as Supervisor
drop table Temp ;
what do you mean by hierarchy load
You may use HIERARCHY load using ID as NodeID, SupervisorID as ParentID.
Qlikview 'Help' gives the details of Hierarchy prefix.