topic Help required for Hierarchy! in QlikView

Help required for Hierarchy!

Tue, 13 Apr 2010 07:45:13 GMT

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

Help required for Hierarchy!

Fri, 16 Apr 2010 11:18:12 GMT

Hi All,

Any one is having solution for this?

Thanks and Regards,

Rikab

Help required for Hierarchy!

Mon, 19 Apr 2010 08:19:33 GMT

Hi Dilip,

I hope the attached application will help you.

Regards

Rajesh

Help required for Hierarchy!

Mon, 19 Apr 2010 11:30:08 GMT

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.

Help required for Hierarchy!

Wed, 02 Mar 2011 08:21:15 GMT

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