Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ferha_jafri
Partner - Creator III
Partner - 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
Partner - Creator III
Partner - 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
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ferha_jafri
Partner - Creator III
Partner - 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
Partner - Creator III
Partner - Creator III
Author

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

ferha_jafri
Partner - Creator III
Partner - 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

Anonymous
Not applicable

Hi Ferha,

how you have resolved this issue?