Databases Reference
In-Depth Information
The new list box will be created. Here we are taking advantage of the hierarchical
path created in one of the fields from the previous exercise. The tree-view list box
only requires a field with the hierarchical definition for a set of values, and with each
hierarchical level separated by a specific character. The separation symbol can be any
character. In the preceding example, we used a minus sign along with a leading and
a trailing space since that's how each value is separated in the actual data.
The following screenshot shows a side-by-side comparison of a "normal" list box and
the tree-view list box. Both use the same field:
As you can see from the preceding screenshot, a tree-view list box is good at
representing hierarchical levels, and provides an easy way to collapse/expand the
hierarchy with the plus and minus icons to the left of each parent value.
When clicking a collapsed parent value, all of its children are selected as well.
Generic load
Another table structure we can come across when loading data into QlikView is
what we call a generic table.
A generic table is commonly used to store attribute values for different objects.
These attributes are not necessarily shared across all objects contained in the table,
and that's one of the reasons why a traditional columnar structure is not used for
these tables.
