Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try with a calculated 2nd dimension
=Dual(Imputacion, Aggr(Sum(Cantidad), Codigo, Imputacion))
and sort it using this expression
Aggr(Sum(Cantidad), Codigo, Imputacion)
Try with a calculated 2nd dimension
=Dual(Imputacion, Aggr(Sum(Cantidad), Codigo, Imputacion))
and sort it using this expression
Aggr(Sum(Cantidad), Codigo, Imputacion)
Well, it works perfect, but, It should not work by checking the option: "By expression" and the expression that we indicate?.
Regards.
It should not work how? Not sure I understand
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.