Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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!!
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.
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.