topic Re: Script Help for handling Vacant Managers in Hierarchy in QlikView

Script Help for handling Vacant Managers in Hierarchy

aveeeeeee7en — Tue, 01 Jul 2014 11:00:22 GMT

Dear Community

Please see the Attachment and help me in writing the correct Script for for handling Vacant Managers in Hierarchy.

Regards

Aviral

Re: Script Help for handling Vacant Managers in Hierarchy

hic — Tue, 01 Jul 2014 11:28:54 GMT

You cannot use 'Vacant' as ID for an employee. You need to create a unique ID for each position, e.g.

'Vacant' &'_'& DivisionalHead &'_'& MANAGER_POSN as ID

Further, you need to use this ID both as [EmpID] and [Reporting To].

HIC

Re: Re: Script Help for handling Vacant Managers in Hierarchy

aveeeeeee7en — Wed, 02 Jul 2014 05:26:38 GMT

Thank You Henric Sir for your response

I have a requirement to fill Nulls with 'Vacant' in Hierarchy at the same position where the person was earlier. Every person has its Manager Position.

I have worked on the Logic but got stuck at one point, to adjust person at similar place where it was earlier.

Kindly see the Attachment.

Regards

Aviral Nag

Re: Script Help for handling Vacant Managers in Hierarchy

aveeeeeee7en — Wed, 02 Jul 2014 10:05:35 GMT

Any Suggestions.

Re: Re: Script Help for handling Vacant Managers in Hierarchy

hic — Wed, 02 Jul 2014 10:31:09 GMT

You are mixing Employee ID with Employee Name, and that's why it doesn't work:

A solution can be found in the attachment.

HIC

Re: Script Help for handling Vacant Managers in Hierarchy

aveeeeeee7en — Thu, 03 Jul 2014 03:27:19 GMT

Thank You Henric Sir

It works. Perfect Solution. That's New Learning to me. Never seen something like this before. Incredible Stuff.

Regards

Aviral Nag