Discussion Board for collaboration on QlikView Layout & Visualizations.
It is possible to use PivotTable estutura tree? ie, in a column to show the hierarchy between the dimensions?
Go to Solution.
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,