qlikview tree representation

[#1]

Hello

which structure I must to use to represente in QLIKVIEW

dynamic tree ?

do not know in advance how many levels of the trees.

Should I use the load statement the hierachy load ?

If I use hierachy I have this error

HIERARCHY parameter NodeName  is not a valid field....

Could you help me?

Regards

Oronzo

[jonathandienst]

Oronzo

Others would be better able to help you if you posted the complete load statement, or a qvw file containing the load in question

Regards

Jonathan

[#3]

You have right. The Load  Statement is from mysql database

Maybe I don't understand how to use correctly the statement Hierarchy

Hierarchy(GDO_cli, GDO_sup, GDO_des ) Load

     GDO_cli as l_cdc,

     GDO_sup as l_sup,

     GDO_des as l_des

resident gdoret;

Regards

Oronzo

[jonathandienst]

Oronzo

Minimum paramaters for Hierarchy are

     Node ID

     Parent Node ID

     Node Name

Is this what you have?

You should get a table containing all the fields in you LOAD statement, plus the Node ID, Node Name, and a set of field named [Node Name1], [Node Name2], ... [Node NameN] which represent the succesive parents to the top of the tree (Node Name1).

For example:

tmpDimDealClass:
LOAD CD AS DealClass.ID,          // node ID
    NAME AS DealClass.Name,       // node name
    SUP_CD AS DealClass.Parent;   // parent node ID
SQL SELECT *
FROM OUTPUT.DIM_DEAL_CLASS;
DealClassRollup:
Hierarchy(DealClass.ID, DealClass.Parent, DealClass.Name)
LOAD Distinct * Resident tmpDimDealClass;
DROP Table tmpDimDealClass;

Produces:

DealClass.ID

DealClass.Name

DealClass.Name1

DealClass.Name2

DealClass.Name3

DealClass.Name4

DealClass.Name5

DealClass.Name6

DealClass.Parent

Hope that helps

Regards

Jonathan

[#5]

Thank you

Jonathan your answer was very helpful

Regards

Oronzo