Is it possible to show the hierarchy of a pivot table in vertical form instead of horizontal

[ferha_jafri]

Hello Everyone,

This is really urgent ,i need help as user want to view the hierarchy in the pivot table vertically not horizontally,is it possibble in qlikview ....

eg:

Product1

Product2

Product3

Sub Business Unit

Product4

Product5

Total Bio Pharma

Like this they want to view the hierarchy vertically not horizontally and in front of them they want to view the calculated values..

Thanks in advance

Ferha Jafri

[ferha_jafri]

Hello everyone,

It is urgent as i have to reply back to the user ,in other words i can say that user wants to see all required dimensions in one column and then there calculated expression values in fornt of them.

Thanks in advance

Ferha Jafri

[#3]

Hi,

You have to model the data accordingly so that different product names are under a single product field. Then use this field as a dimension in pivot table. Different values can be added as an expression. Qlikview will show calculate the expression for each product and show.

If you want to know if that is possible, yes it is possible in Qlikview.

[kaushiknsolanki]

Hi,

     It will be better understood if you provide some sample data.

Regards,

Kaushik Solanki

[ferha_jafri]

So we have to basically design the inline table but when i am performing the calculations as the table is not connected it is not fetching the correct data

[#6]

can you attach the QVW?

[ferha_jafri]

I am attaching the qvw i want to create a pivot table as shown below

[ferha_jafri]

Sorry i am not able to attach the file it it very large

[dirk_konings]

Create a table (inline or Excel) like this:

DimensionProduct          Product               SortOrder

Total Bio Pharma            Product1               7

Total Bio Pharma            Product2               7

Total Bio Pharma            Product3               7

Total Bio Pharma            Product4               7

Total Bio Pharma            Product5               7

Product 5                         Product5               6

Product 4                         Product4               5

BusinessUnit                    Product1               4

BusinessUnit                    Product2               4

BusinessUnit                    Product3               4

Product 3                         Product3               3

Product 2                         Product2               2

Product 1                         Product1               1

Where Product should be linked to the product field with values on

SortOrder to sort the dimension correctly and use a StraightTable

Dirk Konings

[Anonymous]

Hi Ferha,

how you have resolved this issue?