Sorting not working correctly

[rsdhavle]

I have one pivot table, it has region and client names as dimensions and then 3-4 columns of different expression..lets say i want to sort based on descending order of one of the expression and also for every region i want to show order as high to low based on that expression..how can it be done?

[qlikoqlik]

Hi Rohan

You can do this in the sort tab of properties, be careful that both the state and text or numeric are sorted the same

Thanks and regards

Padma

[Anonymous]

Hi,

follow this link

http://community.qlik.com/thread/129381

[lironbaram]

hi have a look at the attach example

you should note

that if the inner dimension is connected to more than one dimension

then the sorting of the inner dimension won't work

because it will be sorted on the total of each value in all the model