Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Sorting by third expression

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

Tags (1)
5 Replies
simone_spanio
Valued Contributor

Re: Sorting by third expression

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.

S.

Re: Sorting by third expression

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

Not applicable

Re: Sorting by third expression

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

simone_spanio
Valued Contributor

Re: Sorting by third expression

You can try with Column() function.

S.

Re: Sorting by third expression

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.

See also: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

Community Browser