Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Moving Dimension columns in pivot tables

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

4 Replies
dapostolopoylos
Creator III
Creator III

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...

Father/Husband/BI Developer
Anonymous
Not applicable
Author

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

dapostolopoylos
Creator III
Creator III

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...

Father/Husband/BI Developer
Anonymous
Not applicable
Author

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