Check Sort Order In Logic (Locking Sort Order)

[UncleRiotous]

I don't believe it's possible in Qlik to lock the sort order of a table (please let me know if I can) however I have a table which uses Above in it's logic so if the sort order is changed the values will be wrong. Currently I've got a footnote warning users but it's far from ideal.

I'm wondering if there is a function similar to GetFieldSelections which will let me check what current sorting is. At least that way I could warn the user if they change the sort order of this table.

I need a solution that doesn't use custom extensions.

[sbaro_bd]

Hi @UncleRiotous ,

Indeed, it's not possible to lock or disable the sort option.

I found this workaround on the community : https://community.qlik.com/t5/App-Development/Qlik-Sense-how-to-disable-sort-feature-on-straight-tab...

Perhaps it will work on your use case.

Regards.

[marcus_sommer]

Beside the attempt to disable the sorting or the inter-activity of the object you may take a look if it's applicable in your scenario to wrap the interrecord-functions within an aggr() which sorting would be fixed in regard to the defined dimensions and/or the sorting-parameter.

Such an approach may require further measurements, like set/total statements and/or a further nesting and/or some inside/outside boolean checks ... This wouldn't prevent any user-sorting but the calculation results might be not changing.