How to create hierarchies for the attached table

[ananyaghosh]

Hi,

I want to create hierarchies for the attached excel sheet tables. Please provide me steps how to do that in Qlikview? after creating hierarchies I want to show it in list box.

[Joaquin_Lazaro]

Hi ananyaghosh:

Read this explendid guide made by HIC Hierarchies

Hope this helps

Joaquín

[awhitfield]

Hi Sandip,

another useful link:

https://community.qlik.com/docs/DOC-5490

HTH Andy

[Anonymous]

Hi,

here are some examples:

Hierarchy in QlikView

Hierarchy function easy and Efficient with example---

Regards.

Jannet

[ananyaghosh]

Hi,

I have used below script:-

LOAD CountryID,

     CountryName

FROM

[\\Client\D$\304091\project\data\Dummy data\Country.xlsx]

(ooxml, embedded labels, table is Sheet1);



Region:

LOAD RegionID,

     RegionName,

     CountryID

FROM

[\\Client\D$\304091\project\data\Dummy data\Region.xlsx]

(ooxml, embedded labels, table is Sheet1);



State:

LOAD StateID,

     StateName,

     StateShortDesc,

     RegionID

FROM

[\\Client\D$\304091\project\data\Dummy data\State.xlsx]

(ooxml, embedded labels, table is Sheet1);



City:

LOAD [City ID],

     [City Name],

     [State ID] as StateID,

     latitude,

     longitude,

     zip_code

FROM

[\\Client\D$\304091\project\data\Dummy data\CityDeatils.xls]

(biff, embedded labels, table is [city-4$]);



ITEM:

LOAD Distinct [City Name] as VALUE, [City Name] & '-City' as NODE_ID, [StateID] & '-StateID' as PARENT_NODE_ID resident City;

LOAD Distinct StateName as VALUE, [StateName] & '-State' as NODE_ID, [RegionID] & '-RegionID' as PARENT_NODE_ID resident State;

LOAD Distinct RegionName as VALUE, [RegionName] & '-Region' as NODE_ID, [CountryID] & '-CountryID' as PARENT_NODE_ID resident Region;

LOAD Distinct CountryName as VALUE, CountryName & '-CountryName' as NODE_ID, [CountryID] & '-CountryID' as PARENT_NODE_ID resident Country;



HIERARCHY_TABLE:

Hierarchy(NODE_ID_H,PARENT_NODE_ID_H, ID, PARENT_NAME, NAME, NAME_FOR_TREE) load

NODE_ID,

NODE_ID as NODE_ID_H,

PARENT_NODE_ID as PARENT_NODE_ID_H,

VALUE as ID,

VALUE as NAME

resident ITEM;

And used NAME_FOR_TREE in list box and checked the box tree view. But it does not appear as tree view