Hierarchies in pivot table

[Anonymous]

Hi,

need help on this...

below are the dimension tables, where Range is dimension table with fields as Range1, Range2, Range3 etc... and SuburbCode and StdCode are two seperate dimensions. I want to create a tree view in pivot table.  The Field values for

Range1  Range2    Range3

  X1          Y1              Z1

  X2          Y2              Z2

TableName and their fields

Range    SuburbCode    StdCode

Range1          AB                  1-3

Range2          BC                  3-5

Range3          DE                  5-7

I want to display Hierarchy format in the pivot table.... pfa Excel file

[marcus_sommer]

Have a look for The Crosstable Load to adjust your table-structure and then should this with a pivot possible.

- Marcus

[Anonymous]

Crosstable load doesn't fit my requirement Marcus, as I have  non-hierarchial dimensions connected to fact table (i.e Range ,Suburdcode and stdcode are connected to Fact table seperately). how to acheive this for non heirarchial dimensions. Any Idea...

John

[marcus_sommer]

Your excel looked that a crosstable-load could be one measure to transform the data in the direction of a normal structured table - which needs to be the aim. Probably you need further various multiple filter to exclude the garbage and Peek() or Previous() ? to fill respectively adjust the other cells/rows - very helpful is the table-wizard for this which had a lot advanced options to transform unwell formed data-structures. Unfortuntalely is this tool not well documented but here is an explanation available: QlikView 11 for Developers and this will be helpful, too: Get started with developing qlik datamodels.

- Marcus

[Anonymous]

Thnks Marcus, your ideas made me to think an alternate to acheive this...,

As always Qlik Community rocks....

[Anonymous]

see this as well:

Hierarchy in QlikView

How to make Hierarchy In Qlikview

Hierarchy and Tree View in Qlikview