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