topic Re: Date field not recognized in Date Picker widget in App Development

Date field not recognized in Date Picker widget

Darren1 — Tue, 01 Jun 2021 14:23:49 GMT

The Date Picker widget does not recognize my date field. I have tried many load script solutions, however it does not format the date correctly. The [provisioned_on] is the field I would like to convert to a date. The [provisioned_on] format going into Qlik is "2018 Mar 23 12:00:00 AM". When I open the Date Picker drop down menu to "select a value" the provisioned_on field is missing (attached pic). Are there limitations to the Date Picker widget?

previous load scripts that do not work:

//Date(Timestamp#([provisioned_on],'YYYY MMM DD hh:mm:ssTT'),'YYYY-MM-DD') AS "Provisioned On",
//Date(Date#(provisioned_on,'YYYY MMM DD hh:mm:ssTT'),'YYYY-MM-DD') AS "Provisioned On",
//Date(Date#(left(provisioned_on,10),'YYYYMMDDhh:mm:ssTT'),'YYYY-MM-DD') AS "Provisioned On",
//Date(Floor(Date#([provisioned_on],'YYYY MMM DD hh:mm:ssTT')),'YYYY-MM-DD'),
//Date([provisioned_on], 'YYYY-MM-DD') AS "Provisioned On",
//Timestamp(Timestamp#([provisioned_on], 'YYYY-MM-DD')) AS [provisioned_on],
//Date(Date#([provisioned_on], 'YYYY-MM-DD')) AS [provisioned_on],
//Date(Date#([provisioned_on], 'YYYY-MM-DD')) AS [provisioned_on],

I am running Qlik Sense February 2021

Thanks

Darren

Re: Date field not recognized in Date Picker widget

rwunderlich — Tue, 01 Jun 2021 20:03:22 GMT

The Date Picker dropdown will only show fields that have Date values. Your field is a Timestamp.

Extract the date portion using Floor() to make it a proper date.

Date(Floor(Timestamp#([provisioned_on],'YYYY MMM DD hh:mm:ssTT')),'YYYY-MM-DD') AS "Provisioned On"

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Date field not recognized in Date Picker widget

Darren1 — Tue, 08 Jun 2021 18:00:26 GMT

Thank you for a detailed response to my Date Picker issue. The Load Script you provided formatted the date in the correct format (ex: 2014-04-23). However the "Provisioned On" field is not available in the Date Picker field.

Re: Date field not recognized in Date Picker widget

rwunderlich — Fri, 11 Jun 2021 18:14:28 GMT

I just went through this with a customer last week. The issue is that the Date Range Picker only offers fields that have the $date tag. The workaround is to force the tag. Add this line to the end of your script.

Tag "Provisioned On" with '$date';

I haven't figured out why the tag is not automatically assigned in some cases. I think it has to do with the field not being a proper date the first time it's created.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Date field not recognized in Date Picker widget

Darren1 — Fri, 11 Jun 2021 16:08:08 GMT

Thanks again for the follow up. Your solution to add a tag is exactly correct. Once I added the tag to the load script the field became available in the Date Picker widget.

Re: Date field not recognized in Date Picker widget

SET_Padawan — Fri, 21 Jul 2023 02:25:45 GMT

Hello! I have the same issue, just wondering exactly where I should be putting these lines of code?

Re: Date field not recognized in Date Picker widget

Darren1 — Fri, 21 Jul 2023 11:38:39 GMT

I placed the Tag under the autogenerated autoCalendar which is in my first Section