topic How Do I Sort an Expression Field? in QlikView

How Do I Sort an Expression Field?

Wed, 25 Jan 2012 00:16:35 GMT

This makes absoutely no sense - in SSRS or any other tool I can sort values from highest to lowest but I cannot find a way to do it in Qlikview.

I have expression fields and I need to call-out values by sorting them. How do I do this?

How Do I Sort an Expression Field?

swuehl — Wed, 25 Jan 2012 00:41:40 GMT

You should be able to just sort using the sort order set in the sort tab of the chart properties. If interactive sort is allowed in that tab, double clicking a header will sort the column, flipping asc / desc sort order.

However, there are some chart expression functions, e.g. namely the chart inter record functions like rangesum(), that disable sort of y-values. Do you use any of these functions?

How Do I Sort an Expression Field?

jagan — Wed, 25 Jan 2012 07:54:13 GMT

Hi,

For straight table

Goto Chart Properties -> Sort -> Select expression and give the required sorting (Ascending/Descending)

In Bar chart etc

Goto Chart Properties -> Sort -> Select "Y value" and give the required sorting (Ascending/Descending)

Hope this helps you.

Regards,

Jagan.

How Do I Sort an Expression Field?

SunilChauhan — Wed, 25 Jan 2012 09:07:38 GMT

uncheck all check box in sort tab of chart

and select dimension

then check y value and select descending

hope this helps