Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
User93
Contributor III
Contributor III

Permanently sort a field

Hi all,

I would like to have a custom sort on a dimension, but I would like to have it permanently, so users don't have to configure the sorting each time they use the field on a graph.

I checked all possibilities, but all except one require to configure the graph each time with a sort by expression.

However I found one solution with the SortCriterias in the Qlik Sense knowledge base, but I am a bit confused on how to use it.

Do I have to change something in a parameter file to use it (with qSortCriterias) ?

Do I use the 

IEnumerable<SortCriteria> SortCriterias { get; set; }

formula in an app script next to the field I want to sort ?

And, if SortCriterias is not easy to use, is there some other way to indeed permanently put a custom sort on a field so the field is automatically sorted everywhere in the app ?

Best regards.

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can load a temp table to establish a load sort order. Then uncheck all sort options on the chart to use load order. Still requires chart configuration, but you don't have to paste an expression.

https://qlikviewcookbook.com/2012/11/establishing-a-sort-order/

rwunderlich_0-1763138108849.png