Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
wdchristensen
Valued Contributor

Unable to Sort in QlikSense April 2018 SP 1

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. 

7 Replies
benrig44
New Contributor III

Re: Unable to Sort in QlikSense April 2018 SP 1

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/Dua...

 

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

Partner
Partner

Re: Unable to Sort in QlikSense April 2018 SP 1

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).
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
wdchristensen
Valued Contributor

Re: Unable to Sort in QlikSense April 2018 SP 1

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.

wdchristensen
Valued Contributor

Re: Unable to Sort in QlikSense April 2018 SP 1

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.

wdchristensen
Valued Contributor

Re: Unable to Sort in QlikSense April 2018 SP 1

QlikCommunity.PNG

Highlighted
wdchristensen
Valued Contributor

Re: Unable to Sort in QlikSense April 2018 SP 1

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. 

Solutions01.jpg

wdchristensen
Valued Contributor

Re: Unable to Sort in QlikSense April 2018 SP 1

 I changed my sort by expression from:

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

To

=$(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. 

3_StatckOverflow2.png