Hierarchy, tree view, pivot table????

conterperawebs — Sat, 16 Nov 2024 21:15:17 GMT

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?

Re: Hierarchy, tree view, pivot table????

Brett_Bleess — Wed, 20 Mar 2019 21:04:33 GMT

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

Regards,
Brett