topic Re: Hierarchie Issue !!! in QlikView

Hierarchie Issue !!!

amit_saini — Tue, 28 Jun 2016 10:33:29 GMT

Hi Folks,

Attached is my sample application.

Script:

PlantCategories:

LOAD Plant,

[Plant Code],

LeadPlant,

Region1,

[Product Groups]

FROM

(ooxml, embedded labels, table is Sheet1);

tmp_PlantHierarchie:

Hierarchy([Plant Code],LeadPlant, Plant, [ParentName] )

Load

[Plant Code],

LeadPlant,

Plant

resident PlantCategories;

PlantHierarchie:

Left join (PlantCategories) load

[Plant Code],

Plant1 as LeadPlantName

resident tmp_PlantHierarchie;

drop table tmp_PlantHierarchie;

Problem :

Not sure why I'm not getting right value in "LeadPlantName" filed

It should work like below based on Plant Code and LeadPlant entries:

Please help!

Thanks,
AS

Re: Hierarchie Issue !!!

amit_saini — Tue, 28 Jun 2016 12:07:17 GMT

Any suggestions???

Thanks,
AS

Re: Hierarchie Issue !!!

MK_QSL — Tue, 28 Jun 2016 13:01:26 GMT

Try

PlantCategories:

LOAD Plant,

[Plant Code],

LeadPlant,

Region1,

[Product Groups]

FROM

[Book12.xlsx]

(ooxml, embedded labels, table is Sheet1);

tmp_PlantHierarchie:

Hierarchy([Plant Code],LeadPlant, Plant)

Load

[Plant Code],

LeadPlant,

Plant

resident PlantCategories;

Drop Table PlantCategories;

Re: Hierarchie Issue !!!

Anonymous — Tue, 28 Jun 2016 14:36:41 GMT

Hi,

Try using

PlantHierarchie:

Left join (PlantCategories) load

[Plant Code],

Plant as LeadPlantName

resident tmp_PlantHierarchie;

Instead of :

PlantHierarchie:

Left join (PlantCategories) load

[Plant Code],

Plant1 as LeadPlantName

resident tmp_PlantHierarchie;

Since Plant1 does not exist in table tmp_PlantHierarchie.

Re: Hierarchie Issue !!!

amit_saini — Wed, 29 Jun 2016 04:53:59 GMT

Thanks Filip!

Re: Hierarchie Issue !!!

amit_saini — Wed, 29 Jun 2016 05:30:01 GMT

Filip,

"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

Thanks,

Re: Hierarchie Issue !!!

vikramv — Wed, 29 Jun 2016 05:44:12 GMT

Please check the attched ,Is it the same that you are looking for ...

Re: Hierarchie Issue !!!

punitpopli — Wed, 29 Jun 2016 05:53:07 GMT

Hi amit.saini‌,

The below link might help you :

Hierarchy in QlikView

Re: Hierarchie Issue !!!

amit_saini — Wed, 29 Jun 2016 06:18:19 GMT

Sorry,

I'm looking for attached output:

Thanks,

Re: Hierarchie Issue !!!

vikramv — Wed, 29 Jun 2016 07:00:04 GMT

Can you check this....It should work for you..