Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anishphilljoe
New Contributor II

Sorting in Qlik Sense Table and Charts

I am having some trouble understanding sorting logic in Qlik sense. Many a times I have observed that qlik sense desktop app randomly sorts my data (I am sure there is a reason and it just seems random to my untrained eyes). Could someone help understand this behavior. Here are a sample scenarios, would appreciate any explanation behind this behavior.

This table is sorted on Staff Member column and is built by concatenating columns 'SatffMember' and 'EmployeeID'Sorting.PNG

Tags (1)
4 Replies
OmarBenSalem
Esteemed Contributor

Re: Sorting in Qlik Sense Table and Charts

Your image is too small... It's practically unwatchable..

You can always check the sorting "logic" in the properties of the chart, under the sort tab

ogster1974
Honored Contributor II

Re: Sorting in Qlik Sense Table and Charts

Looks like it's sorted on row number and usually as a default it uses the first measure ascending.

If you want to use other columns you can reorder in the sorting section of your chart/table.

If you want to sort on dimension an use sort by expression and set this to staff member and you will get the appearance you are looking for.

Regards

Andy

anishphilljoe
New Contributor II

Re: Sorting in Qlik Sense Table and Charts

Thanks Andy, that helped.

ogster1974
Honored Contributor II

Re: Sorting in Qlik Sense Table and Charts

No problem. Please mark any answers as helpful or correct to assist others.

Regards

Andy

Community Browser