topic Re: The Above() function is messing with an object's sorting order in App Development

The Above() function is messing with an object's sorting order

julioarriaga — Sat, 16 Nov 2024 05:29:20 GMT

I built a table whith a Dimension, (Dime); an expression, SUM(Expre); and another expression:

The last one is used to build a cumulative percentage of the SUM.

I have sorting priority with the SUM(Expre) expression, but whenever I add 2nd expression, it messes around my sorting order . How can I stop this from happening?

I add the data of the table loaded, evidence images and a qvf with the error replicated in it.

Infinite thanks to everyone in this forum, you're always inmmensively helpful and I appreciate it.

1) Data2) Table with just 1st expression3) Table with 2nd expression that messes the order

Re: The Above() function is messing with an object's sorting order

Gysbert_Wassenaar — Tue, 25 Jun 2019 14:50:51 GMT

Yes, using inter-record functions disables some sorting options:

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/inter-record-functions-charts.htm

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: The Above() function is messing with an object's sorting order

julioarriaga — Tue, 25 Jun 2019 15:30:05 GMT

So, I suppose I should use the aggr function in order to make it work, right? Thanks a lot for the clarification!

Re: The Above() function is messing with an object's sorting order

Gysbert_Wassenaar — Wed, 26 Jun 2019 07:57:49 GMT

Yes, that's correct. But you need to sort the aggr too with what's called a 'structured parameter':

sum(aggr(rangesum(above(count(Expre),0, RowNo())), (Dime,(=Count({1} Expre),Desc)) )) / count( total Expre)