topic Hierarchy in a List Box in QlikView

Hierarchy in a List Box

danialier — Mon, 20 Jan 2014 15:02:18 GMT

Hello,

I have a List Box as follows:

I want the list box to show a hierarchy as follows:

B (must be the sum of B1 and B2)

D (must be the sum of D1 and D2 and D3)

How I can do that ?

Thanks,

dani

Re: Hierarchy in a List Box

Nicole-Smith — Mon, 20 Jan 2014 15:11:53 GMT

First you need a hierarchy load like the following:

OrgHierarchy:

Hierarchy (HierarchyOrgId, HierarchyOrgParentOrgId, HierarchyOrgName, , HierarchyOrgName, OrgTreeView)

LOAD OrgId as HierarchyOrgId,

    ParentOrgId as HierarchyOrgParentOrgId,

    Org as HierarchyOrgName,

    OrgId

RESIDENT OrgTable;

Then you can use the OrgTreeView field in a list box and choose to Show as TreeView: