Discussion Board for collaboration on QlikView Scripting.
Attached is my sample application.
(ooxml, embedded labels, table is Sheet1);
Hierarchy([Plant Code],LeadPlant, Plant, [ParentName] )
Left join (PlantCategories) load
Plant1 as LeadPlantName
drop table tmp_PlantHierarchie;
Not sure why I'm not getting right value in "LeadPlantName" filed
It should work like below based on Plant Code and LeadPlant entries:
Hierarchy([Plant Code],LeadPlant, Plant)
Drop Table PlantCategories;
Plant as LeadPlantName
Instead of :
Since Plant1 does not exist in table tmp_PlantHierarchie.
"Plant as LeadPlantName" this is giving me entries , but not the correct one.
It should be like below:
For example : Against "50016 Zaragoza, Spain" I should get output as "KT Barcelona" in LeadPlantName , because see below Lead Plant code is 11
Please check the attched ,Is it the same that you are looking for ...
The below link might help you :
Hierarchy in QlikView
I'm looking for attached output:
Can you check this....It should work for you..