How do I create a hierarchy for this data within a Qlikview Script?

Sun, 31 Jul 2016 08:37:35 GMT

Input Table:

Code	Series
1.01	1.01 Metric 1.01
1.02	1.02 Metric 1.02
A.01.01.01	1. Number 1
1.03	1.03 Metric 1.03
1.04	1.04 Metric 1.04
1.05	1.05 Metric 1.05
A.01.01.02	2. Number 2
A.01.01	A. Category A
1.17	1.17 Metric 1.17
A.01.02.01	1. Number 1
1.18	1.18 Metric 1.18
1.19	1.19 Metric 1.19
1.2	1.20 Metric 1.20
1.21	1.21 Metric 1.21
A.01.02.02	2. Number 2
A.01.02	B. Category B
A.01	Pillar 1

Hi,

I have data that looks like the table above and I'm trying to build a hierarchy within the load script.

I assume I'd have to come up with a column such as the one below to link to the parent and then use the Hierarchy() function.

Can someone please help me out with doing this with a load script? The data order and format will be as shown in the table above and the one below is the output I'd feed into Hierarchy().

I would appreciate any help on making this output table, as shown below.

Output Table:

Code	Series	Parent
1.01	1.01 Metric 1.01	A.01.01.01
1.02	1.02 Metric 1.02	A.01.01.01
A.01.01.01	1. Number 1	A.01.01
1.03	1.03 Metric 1.03	A.01.01.02
1.04	1.04 Metric 1.04	A.01.01.02
1.05	1.05 Metric 1.05	A.01.01.02
A.01.01.02	2. Number 2	A.01.01
A.01.01	A. Category A	A.01
1.17	1.17 Metric 1.17	A.01.02.01
A.01.02.01	1. Number 1	A.01.02
1.18	1.18 Metric 1.18	A.01.02.02
1.19	1.19 Metric 1.19	A.01.02.02
1.2	1.20 Metric 1.20	A.01.02.02
1.21	1.21 Metric 1.21	A.01.02.02
A.01.02.02	2. Number 2	A.01.02
A.01.02	B. Category B	A.01
A.01	Pillar 1	-

Thanks!

Re: How do I create a hierarchy for this data within a Qlikview Script?

Anil_Babu_Samineni — Sun, 31 Jul 2016 14:29:11 GMT

Are you expecting like this !

Re: How do I create a hierarchy for this data within a Qlikview Script?

vinieme12 — Sun, 31 Jul 2016 16:07:54 GMT

How do you identify Parent for a Code, do you have a mapping table or Logic?? please explain

Re: How do I create a hierarchy for this data within a Qlikview Script?

Wed, 03 Aug 2016 11:35:49 GMT

Yes, but with the data I have provided. Thanks for the response. I am very new to Qlikview, so could you please adapt such a solution to my data?

topic Re: How do I create a hierarchy for this data within a Qlikview Script? in QlikView

How do I create a hierarchy for this data within a Qlikview Script?

Re: How do I create a hierarchy for this data within a Qlikview Script?

Re: How do I create a hierarchy for this data within a Qlikview Script?

Re: How do I create a hierarchy for this data within a Qlikview Script?