Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort dimension column in pivot table?

Hi awesome people, how do I sort a dimension column in ascending order? Column contains numeric values. And its a pivot table.

1 Solution

Accepted Solutions
v_iyyappan
Specialist
Specialist

Hi,

If u have one dimension means go to sort tab in pivot table properties and set Numeric value ---> ascending. otherwise more than one dimension means which dimension u want sort, that is put in top in dimension properties and set the Numeric value ---> ascending,

Regards,

View solution in original post

6 Replies
Not applicable
Author

Hi,

Go to properties->Sort->Select dimension name->Numeric value ->Ascending

Not applicable
Author

right clik on chart

then go to sort tab

then select dimension field

then check numeric value ascending

Not applicable
Author

I did that. Since its a pivot table, or i don't know what, it changes the values order, but doesn't comes up with ascending order.

v_iyyappan
Specialist
Specialist

Hi,

If u have one dimension means go to sort tab in pivot table properties and set Numeric value ---> ascending. otherwise more than one dimension means which dimension u want sort, that is put in top in dimension properties and set the Numeric value ---> ascending,

Regards,

Not applicable
Author

Hi,

Select the Load Order->original option

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Take into account that defining a sort order in a pivot table has limited use, as your document users are allowed to rearrange or pivot columns in all sorts of ways. Most often, there will seem to be no immediate explanation for why QlikView orders a pivot table in a particular way (for example if you define two expressions and sort them differently.)

Peter