Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
alex59800
New Contributor

Customer Hierarchy issue script

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

2 Replies
alex59800
New Contributor

Re: Customer Hierarchy issue script

please ? anyone could help me ?

Thanks a lot

Not applicable

Re: Customer Hierarchy issue script

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

Community Browser