Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting limit while building Hierarchy

Hi,

I'm new to QlikView and trying to build charts using Hierarchy concept of Qlikview. Background of what I'm doing - Pulling data from MySQL database and generating charts in Qlikview. I have a resultant table containing ID, Name and ParentID, SomeCount that I get by firing a SQL query.

Additionally this below query -

Hierarchy(ID,Parent,Name,ParentName,Name,Path,'/','Depth')

Now the problem I'm facing is that -

I get the entire child tree while clicking on a parent. However, I just the immediate childs while clicking on a Parent. For Example -

--- Parent

    ------Child 1

    -----------SubChild1

    -----------SubChild1

    -----------Sub-child1

    -------Child 2

    -------Child 3

For the above example - while clicking on Parent, I need only Child 1, Child 2 and Child 3 to be shown. However, currently, even SubChild1, SubChild2, SubChild3 comes along with it.

Is it possible to set a limit while generating charts? Kindly help.

0 Replies