topic Re: Date Sort Removed When Value Selected in App Development

Date Sort Removed When Value Selected

bbergstrom — Sat, 16 Nov 2024 07:00:21 GMT

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.

Re: Date Sort Removed When Value Selected

sunny_talwar — Wed, 19 Dec 2018 16:26:12 GMT

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

Re: Date Sort Removed When Value Selected

bbergstrom — Wed, 19 Dec 2018 16:36:22 GMT

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.

Re: Date Sort Removed When Value Selected

sunny_talwar — Wed, 19 Dec 2018 16:42:41 GMT

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

Re: Date Sort Removed When Value Selected

bbergstrom — Fri, 21 Dec 2018 14:10:38 GMT

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.