topic Re: Hierarchy for Listboxes and Pivot Table in QlikView

Hierarchy for Listboxes and Pivot Table

Thu, 13 Apr 2017 06:58:54 GMT

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

Data Required in this Format

Regards,

Dev

Anil_Babu_Samineni — Thu, 13 Apr 2017 07:35:41 GMT

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

jonathandienst — Thu, 13 Apr 2017 07:43:13 GMT

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

Thu, 13 Apr 2017 08:23:28 GMT

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