topic Customer Hierarchy issue script in QlikView

Customer Hierarchy issue script

alex59800 — Thu, 08 May 2014 08:49:32 GMT

Hi all,

Here is a challenge for scripts experts concerning Hierarchy issue. To be as clear as possible, i attach an excel with my question. Thanks a lot guys for your answer.

Alex

Re: Customer Hierarchy issue script

alex59800 — Fri, 09 May 2014 12:21:52 GMT

please ? anyone could help me ?

Thanks a lot

Re: Customer Hierarchy issue script

Fri, 09 May 2014 13:15:55 GMT

Use the above script and

HIER:

LOAD [HIERARCHY (Father)] as ParentID,

[HIERARCHY (Son)] as NodeID,

[HIERARCHY (Father)] as NodeName

FROM

Hier.xlsx

(ooxml, embedded labels, table is Sheet1);

HIERFINAL:

Hierarchy(NodeID, ParentID, NodeName)

Load

Resident HIER;

Concatenate('HIERFINAL')

LOAD

DISTINCT

NodeName1,

NodeName1 as NodeID

Resident HIERFINAL;

drop table HIER;

Create a table box with NodeName1, NodeName2, NodeName3, NodeID to see the output