Is it the right way of creating Hierarchy?

[#1]

Hi All,

Let me know is it the right way to create the Hierarchy. I have seen some other methods also so got confused as I don't know which is the best way to create the Hierarchy. Also let me know this works!

As per me after loading the mfacname we just concatenated the fields mfacname,itemname and contentname as Hierarchy and then after that we are loading itemname and content. Then in the general tab of the list property selecting the "Show as tree view" then entering the seperator '|' in the box.

new:
Load mfacname,
 mfacname &'|'& itemname &'|'& contentname as Hierarchy,
 itemname,
 contentname
 RESIDENT items;

Though it works is it the right way? Or any other method is there.

Thanks and Regards,

Rikab

[Anonymous]

Hi,

Here's an example on a Hierarchy load I put together to show how a tree view list box works:

http://community.qlik.com/media/p/83652.aspx

[#3]

Hello Johannes and all!

I am not able to over the issue with hierarchy. Have attached the document for the same.

Though the below code which works with the same login as said above. Though the tree view flow is correct while doing the selection it is not working. Requesting you to apply you logic in the document attached by me and give me me solution.

new:
Load ZONE,
 ZONE &'|'& REGION &'|'& AREA &'|'& HQ_DESC as Hierarchy,
 REGION,
 AREA,
 HQ_DESC
RESIDENT data;
<pre>
I want the data in this flow.
1. ZONE 2. REGION 3. AREA 4. HQ_DESC
This is very urgent requirement. Hope to receive your reply soon.
Regards,
Rikab

 </body>