Hierarchy for Listboxes and Pivot Table - Qlik Community

Report Inappropriate Content · ‎2017-04-13

Hi,

I have data at multiple levels and I need it in hierarchy based on levels in Listbox and Pivot Table.

(Levels are dynamic)

Sample Data

ID	NAME	TYPE	LEVEL	PARENT_ID
1	Assembly	SKU	2	7
2	Freight	SKU	3	4
3	MMU	SKU	2	8
4	Profit	SKU	2	7
5	SG	SKU	2	8
6	Testing	SKU	2	7
7	MVA	SKU	1	NULL
8	Loss	SKU	1	NULL
9	Video	SKU	3	6
10	Speaker	SKU	3	3

Data Required in this Format

MVA	Assembly
	Profit	Freight
	Testing	Video
Loss	SG&A
	MMU	Speaker

Regards,

Dev

Anil_Babu_Samineni · ‎2017-04-13

I didn't follow you. would you describe more please.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

jonathandienst · ‎2017-04-13

This is an n-level hierarchy, and is covered here in some detail:

Unbalanced, n-level hierarchies

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2017-04-13

I have only one dimension and I need hierarchy based on Levels and by using the parent ID.

In the Requirement mentioned I need to display like the below format in hierarchical level.

MVA - > Assembly

- > Profit -> Freight

-> Testing -> Video

Loss -> SG&A

- > MMU -> Speaker