Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anutosh_dhar
Contributor

hierarchy continent country

I have the following data

hierarchy_id,node_id,parebt_node_id,name,node_level

=====================================

23    1418422    1418180    ASIA              1

23    1418192    1418422    ARMENIA      2

23    1418198    1418422    BAHRAIN       2

23    1418206    1418422    BHUTAN        2

I want to create hierarchy on continent + country

if any one click asia list of country will open.

I have written the following codes:

hierarchy:

LOAD "HIERARCHY_ID" as Id,

     "NODE_ID" as NodeID,

     "PARENT_NODE_ID" as ParentID,

      NAME as NodeName,

     "NODE_LEVEL" as NodeLevel;

SQL SELECT *

FROM  "HIERARCHY";

//STORE  hierarchy into E:\Extraction\Qvd\hierarchy.QVD;

//Drop table hierarchy;

continent_hierarchy_check:

Hierarchy(NodeID, ParentID, NodeName)

LOAD NodeID, ParentID, NodeName

Resident hierarchy

;

DROP TABLE continent_hierarchy_check;

how will i check my data as well

1 Solution

Accepted Solutions
anutosh_dhar
Contributor

Re: hierarchy continent country

thank you i have done---

Hierarchy(NodeID, ParentID, NodeName,,NodeName,TreeView)

LOAD

NodeID, ParentID, NodeName

Resident hierarchy

;

1 Reply
anutosh_dhar
Contributor

Re: hierarchy continent country

thank you i have done---

Hierarchy(NodeID, ParentID, NodeName,,NodeName,TreeView)

LOAD

NodeID, ParentID, NodeName

Resident hierarchy

;

Community Browser