Display hierarchy parent child

[fabricecallegar]

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

[juraj_misina]

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

[zebhashmi]

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

[juraj_misina]

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.

[fabricecallegar]

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