Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mikegrattan
Creator III
Creator III

Date Range Picker does not recognize date field

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.

 

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

Try changing the load script to:

Date(floor(ReceivedTime))

View solution in original post

6 Replies
m_woolf
Master II
Master II

Try changing the load script to:

Date(floor(ReceivedTime))

View solution in original post

mikegrattan
Creator III
Creator III
Author

That worked.  Thanks!

 

piotrekc
Partner
Partner

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';

imrasyed
Creator II
Creator II

Awesome.

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

tasheer10
Contributor
Contributor

Where should I add that line?

imrasyed
Creator II
Creator II

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