Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Partner
Partner

Hierarchy National

hi,

i have problem with hierarchy, i want to show National-Area-Branch.

i have AreaID , AreaName , BranchID , BranchName coloum.

in table Area, i have all that coloum.



Hier:
Hierarchy (BranchCode, AreaCode, BranchName,AreaName,BranchName,Path)
LOAD
BranchCode,
AreaCode,
BranchName,
recno() as recno
RESIDENT Area;
drop Table Area;



this code just show for Area and Branch, but how can i show it for National (total area). please advice.

Thanks

1 Reply
Partner
Partner

Hierarchy National

anyone can help me?

thanks