Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
veeranj
Creator II
Creator II

Drill Down Data?

HI Qlikview Group,

I Have a table which shows all the employees data and the employees  level.

I want to create a drill down dimension like when i click on employees ,it should show me the below employees and further level data drill down.

Thanks,

Anjee

1 Solution

Accepted Solutions
Not applicable

Hi

please use  this

Hierarchy(emp_id,mgrid, ename)

LOAD emp_id,

     ename,

     mgrid

From hie.xlsx;

you can have mname as the manager.

Hierarchy(emp_id,mgrid, ename,mname)

thanks

Michael

View solution in original post

3 Replies
Not applicable

Hi

please use  this

Hierarchy(emp_id,mgrid, ename)

LOAD emp_id,

     ename,

     mgrid

From hie.xlsx;

you can have mname as the manager.

Hierarchy(emp_id,mgrid, ename,mname)

thanks

Michael

Anonymous
Not applicable

You can create a drill down group of all those fields you want to create a group from document properties. Find attached the test.qvw for your reference.

Hope it helps,


veeranj
Creator II
Creator II
Author

HI Michael,

Thanks for the Solution.

It worked.

Thanks,

Anjee