topic Re: Qlik Sense - Sort Expression with fixed values ? in App Development

Qlik Sense - Sort Expression with fixed values ?

Sat, 16 Nov 2024 10:39:31 GMT

Hi All,

In a pivot table, what would be the sort expression in order to have values of a text column in a pre-defined order ?

This dimension has 10 values and I want both of them to be my column 1 and column 2, others don't matter.

Thank you

Sébastien

Re: Qlik Sense - Sort Expression with fixed values ?

Gysbert_Wassenaar — Mon, 02 May 2016 15:57:43 GMT

Perhaps something like =match(only({1}YourDimensionHere),'Value1','Value2', ...etc, 'Value10'). The list 'Value1','Value2', ...etc, 'Value10' should be in the order you want to sort them.

Re: Qlik Sense - Sort Expression with fixed values ?

Mon, 02 May 2016 21:10:36 GMT

It works perfectly, Thank you very much Gysbert.

Regards, Sebastien

Re: Qlik Sense - Sort Expression with fixed values ?

Fri, 08 Jul 2016 13:05:17 GMT

Found this really helpful, I am working on School Exam grades, so sorting the grades in A*, A, B, C, D, E, F, G, U was helpful.

I f implimented this at a subject level, i.e. English, Maths, Biology, Physics, Chemistry.....but the bar graph has a drill down, i.e. I select English and I can drill down to the classes in English, the expression sort order does not go to that drill down, but I am sure I can make it.

Does anyone know how...?

Re: Qlik Sense - Sort Expression with fixed values ?

Lucius_Artorius_Castus — Thu, 25 Apr 2024 09:18:17 GMT

@Gysbert_Wassenaar Thanks, It worked for me too.