topic Re: Hierarchy Levels wrong - Managers column no data in QlikView

Hierarchy Levels wrong - Managers column no data

Anonymous — Sat, 20 Feb 2016 15:21:17 GMT

Hi All,

I have created Hierarchy Levels with below code:

Hierarchy(EMP_ID,MGR_ID,[EMPLOYEE NAME],Parent,[EMPLOYEE NAME],PATH,'/',LEVEL)

LOAD

EMP_ID, MGR_ID ,[EMPLOYEE NAME]

Resident Employee;

In level 1 there should be only one employee, but its more than one, as lot of employees records don't have managers info populated in manager fields.

Because of missing managers, count of employees in all levels will be wrong.

Is there a way to force the employee's to desired levels,as manager columns data is missing.

Please any help will be appreciated.

Thanks & Regards

Neetha

Re: Hierarchy Levels wrong - Managers column no data

Anonymous — Sat, 20 Feb 2016 15:47:38 GMT

Could you create a dummy Manager record and then, in your script, for rows with no Manager data add the dummy Manager data ?

Re: Hierarchy Levels wrong - Managers column no data

Anonymous — Sat, 20 Feb 2016 16:36:00 GMT

Hi Bill,

Thanks for immediate response.

Creating dummy manager will not push the employee level to lower level.

because i want to push a employee level to below a existing employee in the hierarchy , depending on business unit,etc.

Thanks & Regards

Neetha

Re: Hierarchy Levels wrong - Managers column no data

Anonymous — Sat, 20 Feb 2016 16:53:16 GMT

Could you share some sample data including the Business unit along with your desired output ?

Re: Hierarchy Levels wrong - Managers column no data

Anonymous — Sat, 20 Feb 2016 17:24:54 GMT

Hi Bill,

Thanks ,but can't share, its sensitive data.

Is there a way to solve this,as its huge data,

at level 1 only 1 employee should be there but they are 475 employees.

Because of one level ,rest of the levels count is wrong hugely.

Regards

Neetha

Re: Hierarchy Levels wrong - Managers column no data

Anonymous — Sat, 20 Feb 2016 17:30:57 GMT

Could explain what you mean by push a employee level to below a existing employee in the hierarchy , depending on business unit,etc.

As in what is your push algorithm ?

Re: Hierarchy Levels wrong - Managers column no data

MarcoWedel — Sun, 21 Feb 2016 22:44:11 GMT

completing your data probably makes more sense than developing a sophisticated script that might or might not correct the output in some cases.

hope this helps

regards

Marco

Re: Hierarchy Levels wrong - Managers column no data

Anonymous — Tue, 23 Feb 2016 16:13:29 GMT

Hi Bill,

Thanks for reply,

Push employee level to existing employee of same unit + Business level group 1 + Business level group 2.

other requirement is employee should be pushed to level 4 or lower than that level.

Push in the sense, level 4 or lower than that level employee id should be populated in empty manager id columns for employee at level 1.

Regards

Neetha

Re: Hierarchy Levels wrong - Managers column no data

Anonymous — Tue, 23 Feb 2016 16:15:31 GMT

Hi Marco,

Thanks for reply.

Requested for Data cleansing in database. But it can't be done now.

can't help it.

Regards

Neetha