Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ferha_jafri
Creator III
Creator III

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

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

9 Replies
ferha_jafri
Creator III
Creator III
Author

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


Not applicable

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
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
ferha_jafri
Creator III
Creator III
Author

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

Not applicable

can you attach the QVW?

ferha_jafri
Creator III
Creator III
Author

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

ferha_jafri
Creator III
Creator III
Author

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


dirk_konings
Creator III
Creator III

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

reggiani
Contributor II
Contributor II

Hi Ferha,

how you have resolved this issue?