Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
not able open which you have shared as am using personal edition.
Kindly suggest !!!
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.. !!!
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!!!
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!!
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;