Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Working with hierarchies in Qlickview

I would like to know, how does Qlickview work with unbalanced hierarchies.

Hierarchies in wich branches of the hierarchy descend to different levels.

For example, an Organization dimension contains a member for each employee in a company. The CEO is the top member in the hierarchy, and the division managers and executive secretary are immediately beneath the CEO. The division managers have subordinate members but the executive secretary does not.


Which is th best way to deal with this hierarchies, definng it in the escript editor??. In Business Objects or Microstrategy I have resolved rgis issue repeting the same value in various members in the branch who has less levels.


Any advice to work with this kind of hierarchies will be greaty aprecitted.


Thanks in advance,



1 Reply
petter
Partner - Champion III
Partner - Champion III

Two excellent articles/blogs about hierarchies in QlikView - with clearly written and good examples:

Hierarchies

Unbalanced, n-level hierarchies