Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: How to change positions of dimensions in a pivot table

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

6 Replies

Re: How to change positions of dimensions in a pivot table

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

- Marcus

Re: How to change positions of dimensions in a pivot table

Not applicable

Re: How to change positions of dimensions in a pivot table

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

Re: How to change positions of dimensions in a pivot table

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

Re: How to change positions of dimensions in a pivot table

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

Re: How to change positions of dimensions in a pivot table

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

Community Browser