Hierarchy, tree view, pivot table????

[conterperawebs]

Hi to all,

Please, how can i do this in Qlik Script?

SELECT Lista_Materiales.Padre,

Lista_Materiales_1.Padre AS Hijo_1,

Lista_Materiales_2.Padre AS Hijo_2,

Lista_Materiales_3.Padre AS Hijo_3

FROM ((Lista_Materiales

LEFT JOIN Lista_Materiales AS Lista_Materiales_1

ON Lista_Materiales.Hijo = Lista_Materiales_1.Padre)

LEFT JOIN Lista_Materiales AS Lista_Materiales_2

ON Lista_Materiales_1.Hijo = Lista_Materiales_2.Padre)

LEFT JOIN Lista_Materiales AS Lista_Materiales_3

ON Lista_Materiales_2.Hijo = Lista_Materiales_3.Padre;

I try a lot of things, but i I haven't anything.

Please can you help me?

BR

[Brett_Bleess]

This is way out of my league, but the following might help, sorry I do not have anything better:

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

Regards,
Brett