Table will not sort with RangeSum

[Lauri]

I have a straight table that I can't sort on any measure, and it appears to be due to a measure using the RangeSum and Above functions. I can sort on the dimension column.

In the screenshot below, the table exists twice, with and without that measure. You can see that I have sorted on Sum(Counter) in both, but the first table is still sorted on the RangeSum column.

Is this normal behavior? Can I do something to allow the first table to sort on Sum(Counter)? Thanks for your help.

[sunny_talwar]

I vaguely remember seeing this sort of problem in QlikView a while ago. It had to do with RowNo().... but coming back to your question... can you may be try to sort your dimension using an expression Sum(Counter)

I guess it was Above() and not RowNo(). Thanks Gysbert!!

[Gysbert_Wassenaar · Accepted solution]

The Above() function turns interactive sorting off. That's unfortunately unavoidable if you use inter-record functions like Above().

As stated in the help page for the inter-record functions: https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inte...

Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when chart inter-record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.

[Lauri]

Thanks for the very quick replies!

I take Gysbert's answer as correct, and I *think* it is supported by this in the Qlik Help, though it's a little cryptic to me:

A column segment is defined as a consecutive subset of cells having the same values for the dimensions in the current sort order. Inter-record chart functions are computed in the column segment excluding the right-most dimension in the equivalent straight table chart. If there is only one dimension in the chart, or if the TOTAL qualifier is specified, the expression evaluates across full table.