topic Re: Sorting by third expression in QlikView

Sorting by third expression

Fri, 13 Feb 2015 08:13:49 GMT

Hi Friends,

I have created a pivot chart with some dimensions and three expressions.

Now I want see the data always sorted in Descending order by third expression.

Thanks

Re: Sorting by third expression

simospa — Fri, 13 Feb 2015 08:18:27 GMT

Hi,

in Properties - Sort tab - select the dimensions and then check Expression flag, choose Ascending or Descending and specify in the box the formula of expression you want sort by.

For example, if your third expression is sum(amount), write sum(amount) in that box.

Let us know.

Re: Sorting by third expression

alexandros17 — Fri, 13 Feb 2015 08:21:47 GMT

in the sort tab use the name of the field in the "expressionn" box

Re: Sorting by third expression

Fri, 13 Feb 2015 08:28:55 GMT

Thanks for reply

Is there any way to see my data always sorted by the third expression irrespective of selection of dimensions and grouping.

Thanks

Re: Sorting by third expression

simospa — Fri, 13 Feb 2015 08:34:11 GMT

You can try with Column() function.

Re: Sorting by third expression

Peter_Cammaert — Fri, 13 Feb 2015 08:47:46 GMT

Sorting rows in a pivot table is always tricky, because a pivot table can have different aggregation levels (eg partially collapsed rows). Take into account that a solution for a specific layout may not work when your start manipulating that layout or pivoting your table.