Creating Drill Down based on supervisor ID

[cwitman1]

Is it possible to create a drill down based off of only the supervisor name

Employee Name	Supervisor Name
Chris	Mike
Rob	Mike
Dylan	Paul
Lisa	Paul
Paul	John
Mike	John
John	Roger

I want to start with John drill into Paul and Mike, if click Mike receive Chris and Rob and if click Paul receive Dylan and Lisa. Is this possible?

[MK_QSL]

This?

Creating a drill-down dimension ‒ Qlik Sense

[cwitman1]

No, I only have one dimension to drill off of and that is supervisor name

[MK_QSL]

You mean to say you don't have Employee Name field?

[cwitman1]

I have employee name field. But I want it to be 3 levels  not two.

• John
• Paul/Mike
• If click Paul: Dylan/Lisa ----- If click Mike: Chris/Rob

[rittermd]

Maybe I am missing something.

But if you have a filter for Supervisor Name when you select one of them you will then see the employees associated with them by default.  That is what Qlik does.

[MK_QSL]

Sorry but I am confused now... Can you tell me exactly what you have and what you want..

[rodrigomartinez]

Temp:

LOAD * INLINE [

    Employee, Supervisor

    Roger,

    Chris, Mike

    Rob, Mike

    Dylan, Paul

    Lisa, Paul

    Paul, John

    Mike, John

    John, Roger

];

FinalTable:

HIERARCHY([Employee], [Supervisor], [Employee Desc], [Employee Parent Name], [Employee Desc], [Hierarchy Employee], '/', 'Employee Hierarchy depth')

LOAD

    Employee,

    Supervisor,

    Employee as [Employee Desc]

RESIDENT Temp;

DROP TABLE Temp;

[rupamjyotidas · Accepted solution]

You should use Hierarchy Function . And use the fields created for your drill down.