Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
cwitman1
Contributor III
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
rupamjyotidas
Specialist
Specialist

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

View solution in original post

8 Replies
MK_QSL
MVP
MVP

cwitman1
Contributor III
Contributor III
Author

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

MK_QSL
MVP
MVP

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

cwitman1
Contributor III
Contributor III
Author

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
Master
Master

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
MVP
MVP

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

rodrigomartinez
Contributor
Contributor

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
Specialist
Specialist

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

View solution in original post