Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
danansell42
Contributor 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

Re: Qliksense selections tool sort issue

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
Contributor III

Re: Qliksense selections tool sort issue

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

gompa786
Contributor III

Re: Qliksense selections tool sort issue

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

Community Browser