Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

In Pivot Table how to Change Dimension to Column Header

I have this pivot table in Qlikview

LineShiftQuantity
Line 1 First1000
Line 1Second2000
Line 2First1000
Line 2Second3000

Line and shift are USED DIMENSIONS (DIMENSION TAB) quantity is an expression (Expression TAB)

But I need to Dispay the information as follows

LineFirstSecond
Line 110002000
Line 210003000

But I have been unable to do that so far

1 Solution

Accepted Solutions
ramasaisaksoft

Hi Silva,

Just click on your column and drag and drop on the top side and you will get the Row to Columns.

For your better understanding i attached the file also.

If you feel you got the solution for your issue ,please close the thread by clicking "Correct Answer" .

View solution in original post

4 Replies
devarasu07
Master II
Master II

Hi,

Try like attached

ramasaisaksoft

Hi Silva,

Just click on your column and drag and drop on the top side and you will get the Row to Columns.

For your better understanding i attached the file also.

If you feel you got the solution for your issue ,please close the thread by clicking "Correct Answer" .

buzzy996
Master II
Master II

step 1: ur table should pivot table object (seems u r having the same here)

step 2: pres shfit+ctrl and select ur colum (u will see highlighted colour line)

step 3: drop ur selected column as header (drop highlighted colour line as a header just beside on chart titile as a horizontal line)

Not applicable
Author

Thank you everybody for your support specially to Shiva for his detailed instructions