topic Re: Drill Down Data? in QlikView

Drill Down Data?

veeranj — Tue, 25 Mar 2014 07:35:12 GMT

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

Re: Drill Down Data?

Tue, 25 Mar 2014 07:59:40 GMT

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

Re: Drill Down Data?

Anonymous — Tue, 25 Mar 2014 09:07:13 GMT

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,

Re: Drill Down Data?

veeranj — Wed, 26 Mar 2014 04:50:24 GMT

HI Michael,

Thanks for the Solution.

It worked.

Thanks,

Anjee