Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hierarchy

Hi everybody,

maybe some of you could help me.

I am trying to make an Hierarchy out of an Excel but I dont get it to work.

Where is the mistake? I think it has something to do with the different names.


CODE_C:
Hierarchy(CODE_C_NodeID, CODE_C_ParentID, Code_C_Name, CODE_C_ParentName ,CODE_C_NodeName , CODE_C_PathName, '/' ,CODE_C_Depth)
//Load *,
//& CODE_C_Code &'/' &CODE_C_Name &'/' &CODE_C_Acronym as TreeView;
LOAD CODE_C_NodeID,
CODE_C_ParentID,
CODE_C_Code,
CODE_C_Name,
CODE_C_Name as CODE_C_NodeName,
CODE_C_Acronym,
CODE_C_Depth
FROM
[...\Struktur IFS.xlsx]
(
ooxml, embedded labels, table is CODE_C);


Thanks in advance.

Chris

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Hi Chris,

I would suggest you to create a Hierarchie excel sheet like attached and than call in QlikView.

Thanks,

AS

View solution in original post

5 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Christian,

Can you please post your .xlsx?

Cheers

Andy

amit_saini
Master III
Master III

Hi Chris,

I would suggest you to create a Hierarchie excel sheet like attached and than call in QlikView.

Thanks,

AS

Not applicable
Author

Hi Christian

As i can see from above error code there should be something wrong with Excel sheet naming convention so you should check the appropriate name of field  are match with each other mapping option or what? or alternatively you can attached you sheet that you are trying to import.

thanks

tresesco
MVP
MVP

Field name is case sensitive. Try with proper case for Code_C_Name  like:

Hierarchy(CODE_C_NodeID, CODE_C_ParentID, CODE_C_Name, CODE_C_ParentName ,CODE_C_NodeName ,

Not applicable
Author

Hi everybody,

very much thanks for your help. It worked.

Chris