topic Re: Varied depth in Hierarchy in QlikView

Varied depth in Hierarchy

anagharao — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to display a skewed hierarchy in a list box (Treeview). However i'm encountering many blanks in the middle.

Please help.

Regards,

Anagha

Re: Varied depth in Hierarchy

sujeetsingh — Wed, 08 Jun 2016 07:09:51 GMT

Seems you data is not as it should be. Refer this thread.

Hierarchies and Tree-view List Boxes

Re: Varied depth in Hierarchy

marjan_it — Wed, 08 Jun 2016 07:44:58 GMT

I think your data is not proper for using hierarchy. for hierarchy sample you need a table with 3 column. ID, Name and ParentID.

and you can load our data like this.

hierarchyData:

load *[

ID,

Name,

ParentID];

Hierarchy(ID,

ParentID,

Name,d,Name, hierarchyData, '-'

)

LOAD

ID,

ParentID,

Name

Resident

hierarchyData;

drop Table hierarchyData;

Re: Varied depth in Hierarchy

anagharao — Thu, 09 Jun 2016 05:21:57 GMT

Hi,

Thank you for the reply.

I however dont have a parentID in my source. i do have the level of the leaf node in each row. Could you please help me in obtaining the parentID?

Also, I manually added the parent ID and created a heirarchy with the function you specified. It works well when i select the lowest level in the tree however it does work with the parent or ancestors.

Regards,

Anagha

Re: Varied depth in Hierarchy

anagharao — Thu, 09 Jun 2016 08:53:46 GMT

Hi guys...

got it!!!

I was missing the hierarchybelongto() part.