sorting in pivot table

[#1]

Is there a way for intarective sort in pivot table like the straight table?

[#2]

Hi

Short answer...NO.

You can't have interactive sort in a pivot, some people have introduced buttons to the side of a pivot that are used to set a variable, then the sort expression inside the pivot can be used to effectively provide an interactive sort.

EG: Create a button.  The button sets the value of a variable called SortType. The expression to set the variable says IF(SortType=1,2,1) so the value will be either 1 or 2.

Inside the pivot, create a sort expression on the first dimension, the sort expression will read something like: IF(SortType=1,Sum(Sales),Sum(Purchases))

So, whilst you do have to have a button to the side, this provides you with some form of interactive sort.

[#3]

thank you very much

[er_mohit]

The best way is to sorting in straight able not in pivot table

See the attached file

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

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

[#5]

A straight table is better at sorting than a pivot table: you can sort it according to any column.

for sorting see this link

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

http://community.qlik.com/message/242973

[#6]

Hi Nigel

Thank you. It's helpfull. However, it's not working when we put the sort expression on the first dimension. And when putting it on the last dimension, it's sorting over all the dimension ( ie stepwise).

Any idea how can i fix this?