Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
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

Highlighted
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.

Highlighted
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...