topic Re: give order some pivot table in QlikView

give order some pivot table

Wed, 12 Mar 2014 19:39:54 GMT

for example , if I have a pivot table and I need order by numeric expression
but right to left.

how can I do ?

best regards dear experts.

I send an example

Re: give order some pivot table

alexandros17 — Wed, 12 Mar 2014 19:44:28 GMT

The best way you have to sort is ordering by Y-dimension ...

All other ways are unuseful ...

Re: give order some pivot table

Wed, 12 Mar 2014 19:57:44 GMT

but when I do that , only uses the name of the expression and only order by alphabetic way and I need an order by the value of the expression and it is numeric.

exists some way to do that?

Re: give order some pivot table

alexandros17 — Wed, 12 Mar 2014 20:01:36 GMT

It orders values of the first expression ascending or descending.

Try to use sorting by expression ....

Re: give order some pivot table

stevedark — Wed, 12 Mar 2014 20:55:43 GMT

Sometimes getting sort orders in Pivot tables to do what you want is not straight forward, particularly when you have nested dimensions. If you have a single dimension on the left and another on the top it should be possible to get it to sort right.

On the Sort criteria for the Dimension you have along the top tick the check box for Expression and copy and paste the expression you have for the Pivot into the expression box. You can then chose Ascending or Descending from the drop down box.

Hope that helps.

Steve

Re: give order some pivot table

Wed, 12 Mar 2014 23:04:04 GMT

ok , I got it , just made a sub consult with resident command ,grouping by the field to I wish sort then I use that you said.

tanks a lot.experts