topic Re: sorting in pivot table in QlikView

sorting in pivot table

Wed, 29 May 2013 07:35:35 GMT

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

Re: sorting in pivot table

Wed, 29 May 2013 11:05:55 GMT

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.

Re: sorting in pivot table

Wed, 29 May 2013 11:08:23 GMT

thank you very much

Re: sorting in pivot table

er_mohit — Wed, 29 May 2013 11:16:49 GMT

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

Re: sorting in pivot table

Wed, 29 May 2013 11:17:08 GMT

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

Re: sorting in pivot table

Thu, 09 Jan 2014 09:24:36 GMT

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?