Databases Reference
In-Depth Information
After reloading the script, we should have a new table in our data model with the
following structure:
As you can see, the resulting expanded nodes table has one field for each hierarchy
level, and one record for each node. Additionally, new fields have been created to
show Path and Depth information.
In cases where one node has multiple parents, the expanded nodes table will have
several records for these nodes.
Also, it's important to note that the expanded nodes table will exclude any orphan
nodes, that is, nodes that have no connection to a top-level node. Only nodes
connected to the highest hierarchy level will be kept in the final table.
Once we have a table with this structure, it is easy to use it on the frontend of
the QlikView document, for example, within a pivot table or in a hierarchy
dimension group.
The created fields can also be used in listboxes to make selections. In fact, let's quickly
explore a feature in which we can add a tree-like view to a simple list box.
The tree-view list-box
With the resulting data from the above example, we will create a new list-box object
by following these steps:
1.
Select
Layout | New Sheet Object | List Box…
from the menu bar.
2.
From the
New List Box
window, enter
Tree View
into the
Title
field.
3.
Then, using the
Field
dropdown, select the
Path
field.
4.
Still from the
General
tab, mark the
Show as TreeView
checkbox and
enter a minus sign (
-
), with a leading and a trailing space, into the
With
Separator
field.
5.
Click on
OK
to create the new list box.