Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help required for Hierarchy!

Hi All,

When I use the below script though the hierarchy that has been formed is correct. When I click on any data other data other than content it is not getting selected. I found this code is simple to create the hierarchy rather than using this one which i am not able to understand anything.


// Found this one complicated which is there in the help file
<title>Hierarchy</title><link/>
Hierarchy(NodeID, ParentID, NodeName) Load
NodeID,
ParentID,
NodeName,
Attribute
From data.xls (biff, embedded labels, table is [Sheet1$];



//Simple code but not functioning well
new:
Load mfacname as mfac,itemcode,
mfacname &'|'& itemname &'|'& contentname as Hierarchy,
itemname as item,
contentname as content
RESIDENT items;


Hope some one can help me out.

Thanks and Regards,

Rikab

4 Replies
Not applicable
Author

Hi All,

Any one is having solution for this?

Thanks and Regards,

Rikab

Not applicable
Author

Hi Dilip,

I hope the attached application will help you.

Regards

Rajesh

Not applicable
Author

Hello Rajesh,

Though it works I am not sure how it works. Will be thankful to you if you can explain me how it works.

Not applicable
Author

Hello Rajesh,

can you post the excel-sheet from your example, as i try to build a hierarchy on the basis it.

Thank you,

Michael