In Pivot Table how to Change Dimension to Column Header

[#1]

I have this pivot table in Qlikview

Line	Shift	Quantity
Line 1	First	1000
Line 1	Second	2000
Line 2	First	1000
Line 2	Second	3000

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

But I need to Dispay the information as follows

Line	First	Second
Line 1	1000	2000
Line 2	1000	3000

But I have been unable to do that so far

[devarasu07]

Hi,

Try like attached

[ramasaisaksoft · Accepted solution]

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]

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)

[#5]

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