topic Re: Sort by express does not work after the first field in App Development

Sort by express does not work after the first field

43918084 — Tue, 02 Jun 2020 01:12:24 GMT

I have a pivot table with many fields and I want to sort each of these fields by absolute variance.

So I have applied through sort by expression for each of the field, (FABS(sum([Feb])-sum([Jan]))). But only the first field sort by absolute variance. The others do not.

Hope I can get some guidance on fixing the problem

Below field 1 sort correctly by top absolute variance. But the 2nd screen shows the subsequent fields are sorted incorrectly

Field1 sort correct lyfield 2 sort incorrectly

Re: Sort by express does not work after the first field

Madhur — Tue, 02 Jun 2020 03:42:10 GMT

Hi @43918084

Which version of Qlik Sense you are using. I am using April 2020 version and in that it is possible in a pivot table to define overall sorting order and sorting order at each level.

Re: Sort by express does not work after the first field

43918084 — Tue, 02 Jun 2020 03:49:40 GMT

Thanks a lot. I m still using 2019 version, unfortunately.