topic Moving Dimension columns in pivot tables in QlikView

Moving Dimension columns in pivot tables

Anonymous — Fri, 04 Aug 2017 11:26:25 GMT

Hello all,

I have a pivot table with some dimensions, and expressions, one of the dimsnsion is pivoted as a column, all other dimensions are at the left of the table and I have a total on the right,

can I move one of the dimnsions that is on the left to the right end of the table ?

thanks all

Re: Moving Dimension columns in pivot tables

dapostolopoylos — Fri, 04 Aug 2017 13:51:14 GMT

You can only pivot the dimension as another column but i am not sure if a pivot with many dimensions in the columns are readable.

What you can alternatively do is to change the chart type to straight table and and drag and drop the dimension wherever you want...

Re: Moving Dimension columns in pivot tables

Anonymous — Fri, 04 Aug 2017 14:00:06 GMT

I dont want to pivot another dimension, I want to move one of the dimensions to the end of the table, after the pivoted dimension's columns.

thanks

Re: Moving Dimension columns in pivot tables

dapostolopoylos — Fri, 04 Aug 2017 14:04:52 GMT

If i get this straight, do you want to have a pivot table with dimensions in both the left and right side of the pivot?

I am pretty sure that this cannot be done...

Have you considered using a butterfly chart?

You can see how in the Data Visualization example in your QlikView installation...

Re: Moving Dimension columns in pivot tables

Anonymous — Fri, 04 Aug 2017 15:30:23 GMT

I was hoping for a straightfoward solution, but the butterfly table will have to suffice, its more of a workaround ...