Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
Please find the image attached, and I would like to create a chart in qv exactly the same way as shown in the image. Is this possible to do in qv?
Thanks,
Varun Krishna. P
Hi Varun
Kindly Refer this Post from Sven Uhlig: Tree Visualisation
Hope it will be useful for you.
Regards
Aviral
You need to create Hierarchy Graph , Please find sample.
Vikas
Hi Varun,
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)
Thanks,
AMIT SAINI
this type Of tree structure is possible in qlikview
hope this helps
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
Employee:
LOAD [Employee Number] as EmployeeID,
[Full Name] as Name,
[Primary E-mail],
Manager as ManagerName,
[Employee Number (Manager)] as ManagerID,
Tragets
FROM
User_info.xlsx
(ooxml, embedded labels, table is Sheet1);
Hier:
Hierarchy (EmployeeID, ManagerID, Name, ManagerName,Name, ReportsPath)
LOAD EmployeeID, ManagerID, Name,Tragets, recno() as recno
RESIDENT Employee
;
After loading the data, create the list box using ReportsPath and check "Show as TreeView" in properties
You can also visit following link
http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/11/unbalanced-n-level-hierarchies