topic Re: How to create Hierarchy ? in QlikView

How to create Hierarchy ?

hemanthaanichet — Sat, 28 Oct 2017 17:50:53 GMT

Hi All,

I would like to create a hierarchy for the below scenario

Top level is Country Head like below

Country Head

->State Head

->City Head

->Area Head

Country Head	State Head	City Head	Area Head
Mario	Mario	Mario	Mario
Mario	Sara	Sara	Sara
Mario	Sara	Peiris	Peiris
Mario	Sara	Peiris	Dumi
Mario	Sara	Peiris	Rashm
Mario	Sara	Peiris	Randa
Mario	Saura	Saura	Saura
Mario	Saura	Chaim	Chaim
Mario	Saura	Chaim	Nira
Mario	Saura	Chaim	Ovitiga
Mario	Saura	Chaim	Sani

Regards

Hemanth

Re: How to create Hierarchy ?

el_aprendiz111 — Sat, 28 Oct 2017 18:15:36 GMT

Hi,

1 Option:

=[Country Head] & '/' & [State Head] & '/' & [City Head] & '/' & [Area Head]

Re: How to create Hierarchy ?

hemanthaanichet — Sat, 28 Oct 2017 18:20:29 GMT

I need this in edit script... Using hierarchy function kind off....

Re: How to create Hierarchy ?

sharpjoki — Mon, 30 Oct 2017 00:00:18 GMT

Hi.

Change the table in the script to this:

TreeElements:

LOAD * INLINE[

Element Parent

Mario -

Sara Mario

Peiris Sara

Dumi Peiris

Rashm Peiris

Randa Peiris

Saura Mario

Chaim Saura

Nira Chaim

Otiviga Chaim

Sani Chaim

Then apply the function Hierachy:

Hierarchy(Element, Parent, , , 'TreeElement')

LOAD

Element,

Parent

Resident TreeElements;

Then display the TreeElement field as listbox, selecting the "Show as Tree view", as in example above.

Re: How to create Hierarchy ?

woshua5550 — Mon, 30 Oct 2017 04:12:02 GMT

What is your original data looks like ?

Re: How to create Hierarchy ?

techvarun — Mon, 30 Oct 2017 04:34:13 GMT

Hierarchy function easy and Efficient with example---

Re: How to create Hierarchy ?

techvarun — Mon, 30 Oct 2017 04:37:21 GMT

Check the attached

Re: How to create Hierarchy ?

hemanthaanichet — Mon, 30 Oct 2017 06:00:26 GMT

The data has to be look like below:

->Mario

->Sara

->Peiris

->Dumi

->Rashm

->Randa

->Saura

->Chaim

->Nira

->Ovitiga

->Sani

Re: How to create Hierarchy ?

woshua5550 — Mon, 30 Oct 2017 06:11:08 GMT

can you attach a Excel file which contains your sample data ? just want to make sure the data format you have

Re: How to create Hierarchy ?

hemanthaanichet — Mon, 30 Oct 2017 06:41:50 GMT

Dave sample file for you

Re: How to create Hierarchy ?

techvarun — Mon, 30 Oct 2017 06:50:25 GMT

replace the TREE_VIEW Table code like below to get the Hierarchy as you expected.

TREE_VIEW:

LOAD Distinct StateHead as VALUE, StateHead & '-StateHead' as NODE_ID , CountryHead & '-CountryHead' as PARENT_NODE_ID resident ORGANIZATION;

LOAD Distinct Cityhead as VALUE,Cityhead & '-Cityhead' as NODE_ID, StateHead & '-StateHead' as PARENT_NODE_ID resident ORGANIZATION;

LOAD Distinct Areahead as VALUE,Areahead & '-Areahead' as NODE_ID, Cityhead & '-Cityhead' as PARENT_NODE_ID resident ORGANIZATION;

LOAD Distinct CountryHead as VALUE,CountryHead & '-CountryHead' as NODE_ID, CountryHead & '-CountryHead' as PARENT_NODE_ID resident ORGANIZATION;