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.
michielvandegoo
Valued Contributor

Hierarchy without parent ?

I have a customer table in which some customers have the same parent. Mostly the customer does not have a parent.

How can I create a hierarchy in this situation? I want to show the ChildID as ParentID when no parent is entered in the database. Easy done with an if statement, but I posted the raw data below in the print screen for your reviewing.

I started with Hierarchy (ChildID, ParentID,ClientKey).

ClientKey will be used to link to the name of the client.

I want to display the Parent to child relation in an listbox.

2016-05-10 11_31_53-QlikView x64 - [D__Auren interne rapportages_MI_Auren_2_Workbooks_CTS hierarchy .jpg

My question: what should the hierarchy statement be to generate the desired List box. With the current statement I don't have a field that acts as as desired

Tags (1)
2 Replies
vsudhakar
Contributor III

Re: Hierarchy without parent ?

WHEN THE DATA  LOAD THE TO NEXT BUTTON MULTIPLE TYPE AT THE STAGE HAVE CROSSTABLE AND HIRCHACHY TO GIVE THE HIERCHAY

Re: Hierarchy without parent ?

If you don't have the Parent ID then your approach is rite

Community Browser