topic Re: Hierarchy parameter NodeName is not a valid field in QlikView

Hierarchy parameter NodeName is not a valid field

Tue, 12 May 2009 06:56:09 GMT

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!

Hierarchy parameter NodeName is not a valid field

mongolu — Fri, 10 Jul 2009 01:30:12 GMT

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

Hierarchy parameter NodeName is not a valid field

mongolu — Fri, 10 Jul 2009 01:32:30 GMT

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

Re: Hierarchy parameter NodeName is not a valid field

Wed, 12 Nov 2014 12:43:19 GMT

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.

Re: Hierarchy parameter NodeName is not a valid field

Fri, 21 Aug 2015 14:57:26 GMT

Hola,

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

Hello,

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