Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
satishqlik
Creator II
Creator II

Issue

Hi All,

am trying to create org structure through hierarchy function

Table, which is having emp no and reporting manager ID.

can anyone help me out on the same.

PFB for your reference!!!

Any help will be appreciated.

Thanks in advance!!!

7 Replies
MK_QSL
MVP
MVP

satishqlik
Creator II
Creator II
Author

not able open which you have shared as am using personal edition.

Kindly suggest !!!

MK_QSL
MVP
MVP

I am 100% sure that you haven't tried to open it.. As the one which I shared in not QVW file.. So no point of Personal edition.

It's an extension object.. !!!

satishqlik
Creator II
Creator II
Author

Hi Manish,

am trying to open .qar file but it is showing error with personal edition popup box.

and when I clik on Qlik Demos: See QlikView in Action | Demo.Qlik.Com

it is showing only launch demo

currently am using qlikview 11 personal edition to get this feature(Org chart) Is it require to install new edition ???

Please suggest

PFB9(capture_demo) for your reference!!!

satishqlik
Creator II
Creator II
Author

Hi Manish,

Thanks for your reply.

Can you check my script (hierarchy function) whether its correct or wrong to get desired output.

and let me know if need any changes.

PFA for your reference!!!

Kindly look at and suggest me.

awaiting for your response.

Thanks in advance!!

satishqlik
Creator II
Creator II
Author

Hi Manish,

In the extension it is asking Path, Name and Popup

I gave ORG(name of tree) as path but not giving accurate result.

Can you look@ my script and suggest where I did wrong

temp:

LOAD Text([Emp No.]) as ID1,

     Text([Reporting Manager Emp ID]) as RM

FROM

<>;

TreeView:

LOAD Distinct

ID1 as Value,

ID1&'-ID1' as Node_ID,

RM&'-RM' as Parent_Node_ID

Resident temp;

LOAD Distinct

RM as Value,

RM&'-RM' as Node_ID,

RM&'-RM' as Parent_Node_ID

Resident temp;

HirTable:

Hierarchy(Node_ID_H,Parent_Node_ID_H,ID,Parent_Name,Name,ORG)

LOAD

Value as ID,

Value as Name,

Node_ID,

Node_ID as Node_ID_H,

Parent_Node_ID as Parent_Node_ID_H

Resident TreeView;