Discussion Board for collaboration related to QlikView App Development.
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 recnoRESIDENT Area;drop Table Area;
this code just show for Area and Branch, but how can i show it for National (total area). please advice.
anyone can help me?