Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using tree structure in the pivot table?

Hi,

It is possible to use PivotTable estutura tree? ie, in a column to show the hierarchy between the dimensions?

example attached

Tanks,

Renato

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Renato,

I think something similar like shown in your excel file should be possible.

You will have to define the hierarchy somehow in your script, I used a simple table to define the dependencies.

Then you could use a pivot table with two dimensions, first the main category (like Moda Masculina), second the subcategories (like the different camisas).

Then you could add partial sums to the dimensions as you like or e.g. enable indent mode on tab style (like in the first chart of my example).

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Renato,

I think something similar like shown in your excel file should be possible.

You will have to define the hierarchy somehow in your script, I used a simple table to define the dependencies.

Then you could use a pivot table with two dimensions, first the main category (like Moda Masculina), second the subcategories (like the different camisas).

Then you could add partial sums to the dimensions as you like or e.g. enable indent mode on tab style (like in the first chart of my example).

Hope this helps,

Stefan

Not applicable
Author

Tanks!

Swuehl