topic Order pivot table by expression in App Development

Order pivot table by expression

spividori — Fri, 29 Dec 2017 19:23:21 GMT

Hi.

I have a pivoting table with 2 dimensions: Codigo and Imputación, I put it in the 2 dimensions that it orders by expression: sum (Quantity), but it orders it only by the first dimension, it does not work when I display the second dimension by Imputation.

Attached example.

Re: Order pivot table by expression

sunny_talwar — Fri, 29 Dec 2017 19:35:45 GMT

Try with a calculated 2nd dimension

=Dual(Imputacion, Aggr(Sum(Cantidad), Codigo, Imputacion))

and sort it using this expression

Aggr(Sum(Cantidad), Codigo, Imputacion)

Re: Order pivot table by expression

spividori — Fri, 29 Dec 2017 20:01:21 GMT

Well, it works perfect, but, It should not work by checking the option: "By expression" and the expression that we indicate?.

Regards.

Re: Order pivot table by expression

sunny_talwar — Fri, 29 Dec 2017 20:02:13 GMT

It should not work how? Not sure I understand

Re: Order pivot table by expression

spividori — Sat, 30 Dec 2017 11:34:29 GMT

Sort by the expression Sum (Quantity) in all dimensions, if I checked that option. Also, if you change the position of the dimensions, the solution that you gave me does not work..

QlikView makes it perfect:

Regards.