topic Re: Using tree structure in the pivot table? in QlikView

Using tree structure in the pivot table?

Sun, 16 Oct 2011 19:04:03 GMT

Hi,

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

example attached

Tanks,

Renato

Re: Using tree structure in the pivot table?

swuehl — Sun, 16 Oct 2011 19:42:25 GMT

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

Re: Using tree structure in the pivot table?

Mon, 17 Oct 2011 23:57:15 GMT

Tanks!

Swuehl