topic How to sort dimension column in pivot table? in QlikView

How to sort dimension column in pivot table?

Wed, 11 Sep 2013 10:20:45 GMT

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

Re: How to sort dimension column in pivot table?

Wed, 11 Sep 2013 10:22:17 GMT

Hi,

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

Re: How to sort dimension column in pivot table?

Wed, 11 Sep 2013 10:24:03 GMT

right clik on chart

then go to sort tab

then select dimension field

then check numeric value ascending

Re: How to sort dimension column in pivot table?

Wed, 11 Sep 2013 10:27:39 GMT

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.

Re: How to sort dimension column in pivot table?

v_iyyappan — Wed, 11 Sep 2013 10:29:26 GMT

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,

Re: How to sort dimension column in pivot table?

Wed, 11 Sep 2013 10:31:17 GMT

Hi,

Select the Load Order->original option

Re: How to sort dimension column in pivot table?

Peter_Cammaert — Wed, 11 Sep 2013 10:40:20 GMT

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