You have to create Hierarchy , Please see below:
Suppose you are having 3 regions North America (Inside this you have plants like NA1, NA2....), Region Europe (RE1,RE2...) and Region Asia (RA1,RA2,.....). You can create a Hierarchy here as you can see below the way I did.
ID ParentID IDName 1 1 North America 2 1 Region Europe 3 1 Region Asia 4 1 NA1 5 1 NA2 6 1 NA3 7 1 NA4 8 2 RE1 9 2 RE2 10 2 RE3 11 2 RE4 12 3 RA1 13 3 RA2 14 3 RA3 15 3 RA4
Now call this sheet in to the Qlikview application , in a list box and Enable the option (Show as a tree view)
It's very simple to create the tree structure using hierarchy.
You can refer to the below sample code which I've used in my app
LOAD [Employee Number] as EmployeeID,
[Full Name] as Name,
Manager as ManagerName,
[Employee Number (Manager)] as ManagerID,
(ooxml, embedded labels, table is Sheet1);
Hierarchy (EmployeeID, ManagerID, Name, ManagerName,Name, ReportsPath)
LOAD EmployeeID, ManagerID, Name,Tragets, recno() as recno
After loading the data, create the list box using ReportsPath and check "Show as TreeView" in properties
You can also visit following link