Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What's the difference between dimension vs Measure sorting? How it works. Do we have any examples or documents specific to it.
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
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?
It sorts the rows as per your defined sort order. This may be what you mean by 'sort the entire table'.
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.
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.