topic Re: In Pivot Table how to Change Dimension to Column Header in QlikView

In Pivot Table how to Change Dimension to Column Header

Wed, 25 Nov 2020 16:16:04 GMT

I have this pivot table in Qlikview

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

But I need to Dispay the information as follows

But I have been unable to do that so far

devarasu07 — Thu, 23 Mar 2017 10:17:32 GMT

Hi,

Try like attached

ramasaisaksoft — Thu, 23 Mar 2017 12:14:16 GMT

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 — Thu, 23 Mar 2017 12:57:09 GMT

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)

Thu, 23 Mar 2017 20:38:09 GMT

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