topic Sorting not working correctly in QlikView

Sorting not working correctly

rsdhavle — Wed, 13 Aug 2014 13:15:44 GMT

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?

Re: Sorting not working correctly

qlikoqlik — Wed, 13 Aug 2014 13:46:51 GMT

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

Re: Sorting not working correctly

Anonymous — Wed, 13 Aug 2014 13:51:35 GMT

Hi,

follow this link

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

Re: Sorting not working correctly

lironbaram — Wed, 13 Aug 2014 14:12:16 GMT

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