Selected information in Listbox

[#1]

Hi Qlik Community,

I am new to Qlikview and trying to address the below requirement.

I need a button for Direct/Indirect Reports. For eg,

A manager may want to see employees directly reporting to him and also employees indirectly reporting to him. I have bulit the hierarchy using the hierarchy function. Now, how to populate the employee list box accordingly??

Eg:My name is Shruti, A works for me.  B works for A.  If I click the Direct Button, then A will appear on my list of people who reports to me.  If I click on the Indirect button, then both A and B appear on my list.

Please Help!

Thanks in Advance,

Shruti

[v_iyyappan]

Hi,

     I have confused. can you attach a sample data for this logic?

Iyyappan

[#3]

Hi Iyyappan,

I am attaching the excel for your reference. It contains sample data and UI mockup. Thanks!

[CELAMBARASAN]

Hi,

     Can you post the Hierarchy script on the table you used?

Celambarasan

[#5]

Please look at script code below:

Directory;
Emp:
LOAD [Emp ID],
     Name,
     [Manager ID] as MANAGER
FROM
sample.xlsx
(ooxml, embedded labels, table is Sheet1);

Hierarchy:
Hierarchy ([Emp ID], [MANAGER], [Name], [Manager Name], [Name], Hierarchy,,MDepth)
LOAD
[Emp ID],
MANAGER,
Name
RESIDENT Emp;

Waiting for some quick suggestions!!

Thanks,

Shruti

[CELAMBARASAN]

Hi,

     You want it to be in list box or in Text object or something else?

Celambarasan