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: 
brindlogcool
Creator III
Creator III

Sorting

What's the difference between dimension vs Measure sorting? How it works. Do we have any examples or documents specific to it.

5 Replies
rahulpawarb
Specialist III
Specialist III

Hello Logesh,

Hope you are doing well!

To apply the sorting in Qlik Sense chart, drag the dimensions and measures to set the sorting priority order. The numbers show the order.

Each of the dimensions and measures can also use custom sort feature. Click the dimension or measure name to open the settings and click the sorting button to switch to Custom sorting. The sorting is either Ascending or Descending.

You can sort the dimensions and measures in three different ways - sort by expression value, sort numerically & sort alphabetically.

Please correct me if I misinterpreted.

Regards!

Rahul

brindlogcool
Creator III
Creator III
Author

Thanks for your response.But I do aware of the above steps  But the question was completely different. What will happen if you do the sorting on the measure column alone without sorting defined in the dimension. Does it sort the entire table or how does it works?

Anonymous
Not applicable

It sorts the rows as per your defined sort order.  This may be what you mean by 'sort the entire table'.

brindlogcool
Creator III
Creator III
Author

Thank's Bill So you are saying if sorting is defined in a measure column and all the other columns are not having any sorting the sorting defined in the measure will sort the entire table? I doubt so.

rubenmarin

Hi Logesh, the default sort is 'load sort' (how they where loaded in script), if you want to keep the measure sort when sorting by dimension, you should add sort by expression in your dimension.

To avoid in measures you can try using Dual(currentExpression, sortExpression) to simulate the sorting by another column, but it will be exported as a text... I didn't tested so much.