is there any way to drill down in rows in a chart?

[Mkh13646]

Hi everyone, 

I would appreciate if anyone can help, 

I have a table 

which shows each employee(the one that has wage code ) and his/her family member, 

I would like to drill down by category, employe and then, at last, his/her family member, 

how can I do this in QlikView?

[petter]

The Pivot Table - not the Straight Table is perfect for drill-downs.

[Architect]

Please use the Pivot table .

[Mkh13646]

thank for the answers, but how can I use a pivot table, the number of family members is different in families, isn't that make a problem?

[petter]

no, not unless you have a data model that make it a problem.

[Brett_Bleess]

Take a look at the following Design Blog post, may be of some help, not sure, I am also including the base URL to that area in case you want to search further there for other ideas.

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett