Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
conterperawebs
Contributor
Contributor

Hierarchy, tree view, pivot table????

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?

 

BRQlik.PNG

Labels (3)
1 Reply
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.