topic Re: Sorting in App Development

Sorting

brindlogcool — Wed, 01 Feb 2017 11:47:22 GMT

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

Re: Sorting

rahulpawarb — Wed, 01 Feb 2017 11:56:47 GMT

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

Re: Sorting

brindlogcool — Wed, 01 Feb 2017 12:02:30 GMT

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?

Re: Sorting

Anonymous — Wed, 01 Feb 2017 14:09:11 GMT

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

Re: Sorting

brindlogcool — Wed, 01 Feb 2017 22:38:03 GMT

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.

Re: Sorting

rubenmarin — Wed, 01 Feb 2017 23:40:28 GMT

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.