Reg:How to peroform Hierarchy?

[#1]

Hi All, Wishes to all of you.I am having a scenario in that I have to make a list box with Hierarchy of Region,Area Id & Country.I found

some of exapmle in community in that all mention of using ID ,which is numeric.In that case in my table there is no numeric fields.Is it possible to create hierarchy with out numeric fields.? so how to do the same.Let me know.

Thanks & Regards

Jai

[amars]

Look for HierarchyBelongsTo() function.

[#3]

Ya I tried,But itz nt working

[SunilChauhan]

hi, jai

hope this will help u

hierarchy(Region,Area Id,Country,,Country,ColumnName,'|');

Load

Region,

Area Id,

Country

from [tablename];

good luck

[#5]

Hi ,

My script is like this.After reloading I could not able to find the solution

hierarchy

(REGION,ID,NAME,,NAME,treeview,'|')

LOAD

NAME

,

ID

,

REGION

FROM

C:\QlickView_StandardCosting\DW_QVD\D_DataArea.Qvd(qvd)

I have atatched my screen shot also

;

[SunilChauhan]

hi jai,

load your data like this

tab1:

Load

......

from table;

hierarchy(.......)

Load

resident tab1;

reload it and in list box -> properties->general->Check show as treeview and with seperator |

good luck

[#7]

Hi Tom,

Thnx for your kind reply.I am trying from yestred day itself.. [:'(] Bt could not able to get the solution....Here with am sending

data file.The way which is present in xls file I need to list out in list box...Kindly do the needful...Bcoz I am running out of time.....