Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I have confused. can you attach a sample data for this logic?
Iyyappan
Hi Iyyappan,
I am attaching the excel for your reference. It contains sample data and UI mockup. Thanks!
Hi,
Can you post the Hierarchy script on the table you used?
Celambarasan
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
Hi,
You want it to be in list box or in Text object or something else?
Celambarasan