Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change positions of dimensions in a pivot table

Hey,

how can I change the positions of dimensions in a pivot table?

Look at my example, there you can see is the dimension run. Normally the positions are 1, 2, 3 but I want for example the positions 2, 1, 3 or the positions 3, 2, 1. Is there any way to do that?

Thank you

1 Solution

Accepted Solutions
rubenmarin

Then you'll need some way the user can input the desired order, maybe using inputfields, check attached file.

View solution in original post

6 Replies
marcus_sommer

You could drag and drop with the mouse - vertically and horizontally with left-click on the column-header and then dragging.

- Marcus

rubenmarin

Not applicable
Author

But I want that a business user should do thtat without scripting.

marcus_sommer

Drag and drop could also a user within the browser - it's quite easy. If it's don't work then is this option disabled - you will find it within the object-properties in tab presentation.

- Marcus

rubenmarin

Then you'll need some way the user can input the desired order, maybe using inputfields, check attached file.

rubenmarin

Hi Marcus, [Run] is a vertical dimension, If I understand it right Hans is looking to sort the values of the [Run] field.