topic Re: Date Range Picker does not recognize date field in App Development

Date Range Picker does not recognize date field

mikegrattan — Wed, 05 Dec 2018 17:25:17 GMT

The new Date Range Picker in Qlik Sense Enterprise November 2018 is not recognizing one of my fields as a valid date field. The field is created during the data load as:

Date(ReceivedTime)

The format of the field prior to Date conversion is DateTimeStamp. The field looks right in a table, and I can select dates manually from a filter panel or from the filter on the column in a table, but it is not listed as a date field in the date range picker. I tried using the custom configuration and manually edited the date range picker to use my field, but it doesn't allow a range of dates to be selected. It will work when choosing Last 30 Days, but not an actual date range, the dates are not able to be selected and are grayed out.

Re: Date Range Picker does not recognize date field

m_woolf — Wed, 05 Dec 2018 17:27:30 GMT

Try changing the load script to:

Date(floor(ReceivedTime))

Re: Date Range Picker does not recognize date field

mikegrattan — Wed, 05 Dec 2018 18:20:26 GMT

That worked. Thanks!

Re: Date Range Picker does not recognize date field

piotrekc — Tue, 23 Apr 2019 09:02:35 GMT

Hi,

In my case I have null values in field and Qlik doesn't regonise this as 'data' type and doesn't show it in range picker.

I solve this by add this line:

TAG field [date field] with '$date';

Re: Date Range Picker does not recognize date field

imrasyed — Mon, 01 Jul 2019 10:39:24 GMT

Awesome.

Thanks for your answer here.It saved my lot of time for which i was scratching my head.

Re: Date Range Picker does not recognize date field

tasheer10 — Thu, 17 Oct 2019 08:40:14 GMT

Where should I add that line?

Re: Date Range Picker does not recognize date field

imrasyed — Mon, 21 Oct 2019 05:58:13 GMT

You can add it anywhere but make sure he field or table has to be Loaded.

Re: Date Range Picker does not recognize date field

sri94aa — Fri, 11 Aug 2023 19:22:01 GMT

Actually this answer made my day!