Hierarchy parameter NodeName is not a valid field

[#1]

Hey guys. I'm trying to bring a tree table into QlikView and I'm getting errors. This is an n-level hierarchy table with a number of root notes. First, I load the adjacent nodes table as follows:

Classifications:

SQL SELECT

ClassificationDescription,

ClassificationId,

ClassificationPath,

ClassificationTreeName,

ParentClassificationId

FROM classification_tree;

So the ClassificationId is the table ID, ClassificationDescription is the node name (not unique). ClassificationPath is a unique node name that includes the entire path (Root/Child1/Child2/Leaf). ClassificationTreeName is the name of the tree root node (there are several in the table). And ParentClassificationId is the ID of the adjacent parent node.

This table loaded fine. Then I tried to create the Expanded Nodes table:

ClassificationsExpanded:

Hierarchy(ClassificationId, ParentClassificationId, ClassificationDescription) LOAD

Classifications.ClassificationDescription AS ClassificationDescription,

ClassificationId,

Classifications.ParentClassificationId AS ParentClassificationId

RESIDENT Classifications;

In this script, ClassificationId is unqualified, otherwise it's qualify *;

When I hit reload, I get the error:

HIERARCHY parameter NodeName (='ClassificationDescription') is not a valid field

I've tried a number of things and nothing works. Can anyone please give me some advice? Thank you so much!

[mongolu]

The SQL Select makes a table named (by default) like the "FROM" table.

So, if you missed the line where you named your table to the QlikView table (from "classification_tree" to "Classifications"), then this is one problem.

Another one is the parameter order of the Hierarchy statement.

- first, it's the ClassificationId and you gave him Classifications.ClassificationDescription;

- second, it's the ParentClassificationId and you gave him ClassificationId;

- and third, finaly, it's the ClassificationDescription and you gave him Classifications.ParrentClassificationId.

And take in consideration that scripting is case-sensitive in QlikView.

_________________

email: mihai@aladin.ro

[mongolu]

Sorry for the first one. Probably i have to use bigger eyes.

[#4]

I'm having a similiar problem:

LOAD

  ORG_CLASSIFICATION,

  %ORG_KEY,

  ORG_COMPANY_NAME,

  ORG_CREATE_DATE,

  ORG_DESCRIPTION,

  ORG_IDENTTY_MANAGER,

  %ORG_SAP_ID,

  ORG_LST_UPDATE,

  ORG_MANAGERS,

  ORG_PARENT_ID,

  ORG_STATUS

From $(vQVD_MASTER_OPENIAM)\$(vTableName).qvd (QVD)

WHERE ORG_STATUS= 'ACTIVE' ;

I had this script working fine but then i wanted to have an hierarchy so I added this,

Hierarchy_Simple:

Hierarchy(%ORG_KEY,ORG_PARENT_ID,ORG_COMPANY_NAME)

Load

%ORG_KEY,ORG_PARENT_ID,ORG_COMPANY_NAME

From $(vQVD_MASTER_OPENIAM)\$(vTableName).qvd (QVD);

And know it gives me this error :

"HIERARCHY parameter NodeName (="ORG_COMPANY_NAME") is not a valid field

Hierarchy_Simple:

Hierarchy(%ORG_KEY,ORG_PARENT_ID,ORG_COMPANY_NAME) "

Load

%ORG_KEY,ORG_PARENT_ID,ORG_COMPANY_NAME

From C:\QlikView\1.datasources\2.QVD\6.OpenIAM\Organization.qvd (QVD)

Is this a sintaxe problem or there are some limitations to NodeName, type or size?

Thanks for any help.

[#5]

Hola,

Prueba colocando la pestaña donde tienes el "HIERARCHY" de primera.

Hello,

Try placing the tab where you have the "hierarchy" of first.