topic qlikview tree representation in QlikView

qlikview tree representation

Wed, 21 Mar 2012 11:44:50 GMT

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

qlikview tree representation

jonathandienst — Wed, 21 Mar 2012 12:13:44 GMT

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

Re: qlikview tree representation

Wed, 21 Mar 2012 12:33:23 GMT

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

Re: qlikview tree representation

jonathandienst — Wed, 21 Mar 2012 12:58:28 GMT

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

Re: qlikview tree representation

Wed, 21 Mar 2012 16:30:02 GMT

Thank you

Jonathan your answer was very helpful

Regards

Oronzo