Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Display hierarchy parent child

Hi,

I have a hierarchy parent/child. I don't know the depht of this hierarchy.

I would like to display this hierarchy in Qlik Sense with the same behavior of a drill-down field.

How can I do that ?

Fabrice

4 Replies
Luminary
Luminary

Hi Fabrice,

you can use approach described here: Unbalanced, n-level hierarchies and then create a drill-down dimension using resulting table.

Hope this helps.

Juraj

Specialist
Specialist

you can find the depth in the hierarchy(field,parent_field,'name','path','/','Depth')

But I think you can't show as drill down in Qliksense you can do that in Qlikview

Luminary
Luminary

You do not have the "tree view" option we had in QlikView, but you can still create a drill-down master dimension for use in charts and filter panes.

Partner
Partner

Thank you for your help,

I need to manually specify each level of the hierarchy with the drill down dimension. 

As I don't know the depht of the the hierarchy (it changes in time) I can't use this...