Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
43918084
Creator II
Creator II

Sort by express does not work after the first field

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 lyField1 sort correct lyfield 2 sort incorrectlyfield 2 sort incorrectly

 

 

 

2 Replies
Madhur
Contributor II
Contributor II

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.

Madhur_1-1591069238978.png

 

 

43918084
Creator II
Creator II
Author

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