topic Re: Table will not sort with RangeSum in App Development

Table will not sort with RangeSum

Lauri — Fri, 02 Nov 2018 14:04:51 GMT

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.

Re: Table will not sort with RangeSum

sunny_talwar — Fri, 02 Nov 2018 14:07:59 GMT

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!!

Re: Table will not sort with RangeSum

Gysbert_Wassenaar — Fri, 02 Nov 2018 14:08:30 GMT

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/InterRecordFunctions/int…

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.

Re: Table will not sort with RangeSum

Lauri — Fri, 02 Nov 2018 14:14:27 GMT

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.