Date Sort Removed When Value Selected

[bbergstrom]

I am using a filter pane in Qlik Sense and as long as no dates are selected in the filter the sorting works fine.  Once a date is selected the grayed out dates are no longer in any sort order.  Is there any way to correct this behavior?

This is in the April 2018 release.

[sunny_talwar]

Are you using an expression to sort the date in the filter object?

[bbergstrom]

Yes.  The field in the filter object is called [Transaction Month].  This is created in the loadscript by doing a MonthName(TransactionDate) AS [Transaction Month].  I am then using the TransactionDate in the expression.

[sunny_talwar · Accepted solution]

Instead of using [Transaction Month] for sort... use Only({1} [Transaction Month])... this will help ignore selection within the sort expression and keep the sort intact

[bbergstrom]

Thanks!  That worked for two of the three I had.  Oddly it did not work for the one field created using the WeekStart() function but that one worked by sorting Numerically.