Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
MVP
MVP

Re: Working with hierarchies in Qlickview

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

Hierarchies

Unbalanced, n-level hierarchies