topic Re: Dinamic Sort on Pivot Table in QlikView

Dinamic Sort on Pivot Table

Anonymous — Mon, 29 Dec 2014 17:20:25 GMT

Hello!

Is it possible to do some "dynamic sort" in a Pivot Table?

For example, in a Straight Table, double clicking on a dimension, the entire table will be sorted by this dimension.

Is there any way to do (or simulate) it on a Pivot Table?

Thanks in advance,

Gabriel Rocha

rwunderlich — Mon, 29 Dec 2014 19:02:49 GMT

You can use the sort "by expression' option and compute your sort order based on selections or variable values that may be set with buttons. See Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level) for an andvanced example.

-Rob

Anonymous — Mon, 05 Jan 2015 16:50:42 GMT

Thanks for the answer, Rob.

I've tried something like this, but nothing so complete as your solution.

But what I was expecting is find a way to do this "sort" with double click or something like this, 'cause our users are used to work this way.

But anyway, thanks for the help.

lyeynant — Wed, 13 Feb 2019 14:34:19 GMT

Hi,

You can do that by creating buttons and using Variable and Expression sort functionality.

1. Create variable vSort

2. Create n Text objects / buttons as number of expressions you want to sort.

Text Object #1 : Set Actions--> Add --> External --> Set Variable --> Variable: vSort Value: 1

3. In Pivot table --> Sort --> Expression create follow formula If( vSort =1 , Sum(Sales), If( vSort=2, Count(Order_Id)...))

Good luck,

Anton