Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: Using tree structure in the pivot table?

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

2 Replies
MVP
MVP

Re: Using tree structure in the pivot table?

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

Re: Using tree structure in the pivot table?

Tanks!

Swuehl

Community Browser