Qlik Community

Qlik Sense App Development

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

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Qliksense selections tool sort issue

Hi All

Is it possible to change the sort order of fields that you have available in the selections tool in Qliksense?

I have a field with month names in it and its displayed alphabetically and users would obviously prefer Jan to Dec.

Thanks

Dan

3 Replies
Highlighted

Is your month field a dual field? Essentially how is Month getting created? Is it Month(DateField) as Month or is it a field from the database? If it is coming from database, may be you can do something like this:

Month(Date#(MonthField, 'MMM')) as MonthField

Highlighted
Creator III
Creator III

Hi Sunny

It is Month(DateField) and definitely stored as a dual function.

If i create a list box on the front end i can sort correctly, however when a user uses the selections tool its still alphabetical. There doesn't seem to be any settings to adjust the way its displayed in the selection tool.

Dan

Highlighted
Creator III
Creator III

Hi,

I am facing the same issue as well when using month in a pivot table... I have even written an expression to manipulate the order but it doesn't seem to work and Qliksense automatically sorts alphabetically.. I have used the same expression for the measure the sort works perfectly fine ...works fine with filter as well..

Thanks