Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anjeepvr
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Drill Down Data?

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

3 Replies
Not applicable

Re: Drill Down Data?

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

subhasmita_kar
Contributor

Re: Drill Down Data?

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,


anjeepvr
Contributor II

Re: Drill Down Data?

HI Michael,

Thanks for the Solution.

It worked.

Thanks,

Anjee

Community Browser