Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Others would be better able to help you if you posted the complete load statement, or a qvw file containing the load in question
Jonathan
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;
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 IDSQL SELECT *FROM OUTPUT.DIM_DEAL_CLASS;DealClassRollup:Hierarchy(DealClass.ID, DealClass.Parent, DealClass.Name)LOAD Distinct * Resident tmpDimDealClass;DROP Table tmpDimDealClass;
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.Parent
Hope that helps
Thank you
Jonathan your answer was very helpful
