Multi-Level Hierarchy

Thu, 09 Dec 2010 21:33:47 GMT

Hello,

I am trying to display a multi-level hierarchy listbox by using the 'Hierarchy load' technique that looks like this:

Business Development ->Worldwide Sales ->Americas -> US Repair -> Korea Repair

Following is the script:

Group:

Hierarchy

(GROUP_ID, RELATED_GROUP_ID, GROUP_NAME, PARENT_NAME, GROUP_NAME, [Group Hierarchy]

)

LOAD

RELATED_GROUP_ID

GROUP_ID

RELATED_GROUP_NAME

GROUP_NAME

RESOURCE_NAME

RELATED_GROUP_ID is the Parent ID and GROUP_ID is the child ID.

//......................................................................................................................

My issue is that it is able to get the list box in the desired manner. However, it gets only one Resource_Name value from each hierarchy and totally excludes the others in the load.

Any ideas?

Multi-Level Hierarchy

Thu, 09 Dec 2010 21:39:07 GMT

Just to elaborate, suppose there are 10 resources available at Business Development -> Worldwide Sales -> Americas level, it will only bring the first resource and exclude the rest 9.

Amit

Multi-Level Hierarchy

Thu, 09 Dec 2010 22:59:45 GMT

I figured it out! All I had to do was load the Resource ID and Resource Name as a separate table joined to the Group ID.

Amit

topic Multi-Level Hierarchy in QlikView

Multi-Level Hierarchy

Multi-Level Hierarchy

Multi-Level Hierarchy