topic Re: 3 Level Hierarchy Problem - Data Available till 2 Levels in QlikView

3 Level Hierarchy Problem - Data Available till 2 Levels

Pulkit_Thukral — Wed, 25 Nov 2020 16:16:04 GMT

All,

Working on a requirement to showcase 3 Levels of hierarchy- Parent,Children, Grandchildren

Data - I am receiving 2 Fields in the Data - Parent ,Child

Problem - To show 3 Levels of Hierarchy, First 2 level can directly be shown from the data. But, for 3rd Level we need to consider Child from 2nd Generation as Parent for 3rd Generation and find its children.

Example-

Parent	Child
A	D
A	E
A	H
B	I
C	K
D	M
D	N
E	Z

If user selects Parent value- 'A'

Then a Pivot chart should be generated with below values

Parent	Child	Grandchild
A	D	M
	D	N
	E	Z
	H

Please help in achieving it.

Thanks,

Pulkit Thukral

Re: 3 Level Hierarchy Problem - Data Available till 2 Levels

kfoudhaily — Thu, 21 Jun 2018 14:27:21 GMT

check this link: Creating Cycle and Drill Groups

Re: 3 Level Hierarchy Problem - Data Available till 2 Levels

Pulkit_Thukral — Tue, 26 Jun 2018 11:36:14 GMT

Kh fou,

Link from your mail defines Cyclic and Drill down properties. I am dealing with the back end data rather than Front end changes.

Thanks