Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
danansell42
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
sunny_talwar

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

danansell42
Creator III
Creator III
Author

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

Anonymous
Not applicable

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