Databases Reference
In-Depth Information
A hierarchy example
Consider the following table which contains hierarchical information about regions
of the world:
Parent
Child
World
Europe
World
North America
Europe
England
England
London
Europe
Italy
Italy
Rome
North America
United States
United States
Washington
United States
New York
The preceding data is the actual format in which the information is stored, but it can
also be read as follows, for easier interpretation:
We can see that the shown hierarchy has 4 levels (World - Continent - Country -
City). Each of these levels should be stored in a different field in the QlikView data
model after expanding the hierarchy.
