topic Hierarchy is not Working in QlikView

Hierarchy is not Working

Anonymous — Wed, 21 Mar 2018 07:23:38 GMT

Hi I tried to Implement Hierarchy in Qlikview but it is not Working for me , Kindly find the Below Details,

Coding Done for Hierarchy:

TREE_VIEW:

LOAD Distinct [State Head] as VALUE, [State Head] & '-StateHead' as NODE_ID , [Country Head]& '-CountryHead' as PARENT_NODE_ID resident ORGANIZATION;

LOAD Distinct [City Head] as VALUE,[City Head] & '-Cityhead' as NODE_ID, [State Head] & '-StateHead' as PARENT_NODE_ID resident ORGANIZATION;

LOAD Distinct [Area Head] as VALUE,[Area Head] & '-Areahead' as NODE_ID, [Area Head] & '-Cityhead' as PARENT_NODE_ID resident ORGANIZATION;

LOAD Distinct [Country Head] as VALUE,[Country Head] & '-CountryHead' as NODE_ID, [Country Head] & '-CountryHead' as PARENT_NODE_ID resident ORGANIZATION;

Hierarchy:

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

NODE_ID,

NODE_ID as NODE_ID_H,

PARENT_NODE_ID as PARENT_NODE_ID_H,

VALUE as ID,

VALUE as NAME

resident TREE_VIEW;

And Also Selected Show as tree view in the List Box Properties.

loveisfail‌pcammaert‌michaelwad‌jimhalpert‌afd‌theresaa‌bpn‌ stalwar1‌

Re: Hierarchy is not Working

Anil_Babu_Samineni — Wed, 21 Mar 2018 13:33:34 GMT

What level Structure we need follow initially?

Re: Hierarchy is not Working

Anonymous — Mon, 26 Mar 2018 05:06:35 GMT

Hi anil i am new to Hierarchy design and using the sample data i try to implement hierarchy, Correct me if any thing i have done Wrong

Re: Hierarchy is not Working

Anil_Babu_Samineni — Mon, 26 Mar 2018 13:05:42 GMT

Whatever you've copied from this link Hierarchy function easy and Efficient with example---Seems, Okay to me. But, you need to explain which is your Parent and Node and so on.. You want to route 4 fields in hierarchy Field?