How to get Organization hierarchy like dir->manager->teamLead->SSE->JSE

[#1]

Hi all,

I am trying to make hierarchy let say for an organization where titles are  DIRECTOR, MANAGER, TEAM LEAD, SSE,JSE AND TRAINEE.

using some dummy data for this . but not getting the right Hierarchy structure . its giving error in script .

hierarchy should become like this 

                                                            DIRECTOR

                                                                 |

                                                             MANAGER

                                                                 |

                                                             TEAM LEAD

                                                                |

                                                            SSE

                                                                |

                                                             JSE

can some one help me in this.

following is the script that I am getting after using the Hierarchy while loading xls file.

HIERARCHY(DIRECTOR, MANAGER, TEAMLEAD, TEST1, SSE, TEST2, /)
LOAD DIRECTOR,
MANAGER ,
TEAMLEAD,
SSE,
JSE,
TRAINEE
FROM SHEET1

Regards

Ravindra Mandre

[#2]

I am also following the example    

http://us.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Extension%20Examples.qvw&host=Demo11

Ravindra Mandre

[#3 · Accepted solution]

Got the answer by following this example

http://community.qlik.com/qlikviews/1072

Ravindra Mandre