Hierarchies

[hic]

Hierarchies are an important part of all business intelligence solutions, used to describe dimensions that naturally contain different levels of granularity. Some are simple and intuitive whereas others are complex and demand a lot of thinking to be modeled correctly.

• What is the difference between a balanced and an unbalanced hierarchy?
• How can a hierarchy be loaded into QlikView?
• Which data model should be used?
• How do I create an authorization scheme using a hierarchy?
• How can I check for data integrity problems in the hierarchy data?

These questions and others are answered in this Technical Brief. Attached you will also find a sample unbalanced, n-level hierarchy along with the script to load it.

See also the following blog posts:

Unbalanced, n-level hierarchies

Authorization using a Hierarchy

HIC

2013-11-26: Added section on authorization.

[Brokenhips]

Hi Henric, just back to Qlik after a number of absent years.

Struggling with heirarchies and could do with some advice/pointers if you have the time

I am trying to create a hierarchy for Make, model,derivative from the below structured data - having already added in the node information.

I am unsure of how this should be loded to produce it ?or even if I actually need to ?

Regards

Parent Node	Manufacturer	Snr Node	Model	Child Node	Derivative
1	ALFA ROMEO	100	GIULIETTA DIESEL HATCHBACK	300	1.6 JTDM-2 120 Tecnica 5dr
2	BMW	101	3 SERIES SALOON	301	330e M Sport 4dr Step Auto
2	BMW	102	5 SERIES DIESEL SALOON	302	520d [190] M Sport 4dr Step Auto
`	FORD	103	ECOSPORT DIESEL HATCHBACK	303	1.5 TDCi 95 Titanium 5dr [17in]
3	FORD	104	FIESTA DIESEL	304	1.5 TDCi Sport Van