Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
New Contributor III

Creating Drill Down based on supervisor ID

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

Employee NameSupervisor Name
Chris

Mike

RobMike
Dylan

Paul

LisaPaul
PaulJohn
Mike

John

JohnRoger

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?

1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Re: Creating Drill Down based on supervisor ID

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

View solution in original post

8 Replies
Highlighted
MVP
MVP

Re: Creating Drill Down based on supervisor ID

Highlighted
New Contributor III

Re: Creating Drill Down based on supervisor ID

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

Highlighted
MVP
MVP

Re: Creating Drill Down based  on supervisor ID

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

Highlighted
New Contributor III

Re: Creating Drill Down based on supervisor ID

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
Highlighted
Honored Contributor

Re: Creating Drill Down based on supervisor ID

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.

Highlighted
MVP
MVP

Re: Creating Drill Down based  on supervisor ID

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

Highlighted
New Contributor

Re: Creating Drill Down based on supervisor ID

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;

Highlighted
Valued Contributor

Re: Creating Drill Down based on supervisor ID

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

View solution in original post