topic Re: Qliksense selections tool sort issue in App Development

Qliksense selections tool sort issue

danansell42 — Fri, 22 Jul 2016 16:33:55 GMT

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

Re: Qliksense selections tool sort issue

sunny_talwar — Fri, 22 Jul 2016 17:35:21 GMT

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

Re: Qliksense selections tool sort issue

danansell42 — Mon, 25 Jul 2016 08:04:39 GMT

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

Re: Qliksense selections tool sort issue

Anonymous — Mon, 25 Jul 2016 09:29:38 GMT

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