Drill Down Data?

[veeranj]

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

[#2 · Accepted solution]

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]

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]

HI Michael,

Thanks for the Solution.

It worked.

Thanks,

Anjee