topic Re: Issue in QlikView

Issue

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

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!!!

Re: Issue

MK_QSL — Sat, 24 Jun 2017 12:48:57 GMT

Use this

https://community.qlik.com/docs/DOC-3892

Re: Issue

satishqlik — Sat, 24 Jun 2017 13:08:15 GMT

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

Kindly suggest !!!

Re: Issue

MK_QSL — Sat, 24 Jun 2017 13:09:23 GMT

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.. !!!

Re: Issue

satishqlik — Sat, 24 Jun 2017 13:35:54 GMT

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!!!

Re: Issue

MK_QSL — Mon, 26 Jun 2017 08:55:37 GMT

Installing and using extension examples ‒ QlikView

http://www.qlikblog.at/2848/qlikview-extension-tutorial-basic-concept/

Re: Issue

satishqlik — Mon, 26 Jun 2017 14:59:22 GMT

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!!

Re: Issue

satishqlik — Tue, 27 Jun 2017 05:09:49 GMT

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;