topic Re: Unable to Sort in QlikSense April 2018 SP 1 in App Development

Unable to Sort in QlikSense April 2018 SP 1

wdchristensen — Sat, 16 Nov 2024 21:51:53 GMT

I have all kinds of trouble with sorting. Sorting seems to work incorrectly in charts, tables, filter lists you name it. I am wondering if there is some new trick to get sorting to work like it does in every other product I have used. It is not sorting a string like a number or something simple rather it is almost like it is sorting on a different column first…. Please see the attached picture for an example.

Re: Unable to Sort in QlikSense April 2018 SP 1

Anonymous — Mon, 19 Nov 2018 22:03:03 GMT

might not be a bug but Qlik's weird (some may disagree) DUAL feature

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/FormattingFunctions/Dual.htm

the value you see on screen isn't necessarily what Qlik sees behind the scenes and it may be sorting on a value you dont expect

Re: Unable to Sort in QlikSense April 2018 SP 1

Vegar — Mon, 19 Nov 2018 22:36:36 GMT

It does not look like a dual to me (left aligned). Check the objekt preference for the sorting setting. It could be that your sorting is not done by alphabetically, it could be sorted by load order (the order the data where loaded into the application).

Re: Unable to Sort in QlikSense April 2018 SP 1

wdchristensen — Tue, 20 Nov 2018 15:24:11 GMT

Vegar, hit the issue exactly. When I try to “sort by expression” it just reverts to the order in the load script. See the example screenshot for an example.

Re: Unable to Sort in QlikSense April 2018 SP 1

wdchristensen — Tue, 20 Nov 2018 15:37:07 GMT

In the attached example above I am attempting to show the cost center description concatenated with the department code but when the user sorts the column I want the sort order to be on the cost center number not the cost center description.

Re: Unable to Sort in QlikSense April 2018 SP 1

wdchristensen — Wed, 21 Nov 2018 15:41:29 GMT

Re: Unable to Sort in QlikSense April 2018 SP 1

wdchristensen — Tue, 27 Nov 2018 15:36:28 GMT

I suspect this is a bug but it is hard to know for sure since there is no publicly available "known issues" list to confirm my suspicions.

Re: Unable to Sort in QlikSense April 2018 SP 1

wdchristensen — Wed, 28 Nov 2018 19:50:47 GMT

I changed my sort by expression from:

=$(vCOST_CENTER_CODE) & ' - ' & $(vCOST_CENTER_DESC)

=$(vCOST_CENTER_CODE)

and it works... If anyone who uses Qlik Sense thinks this is not a bug, please feel free to explain in the comment section below.