topic Re: Load date with pre-defined date functions in App Development

Load date with pre-defined date functions

eddyg — Tue, 15 Nov 2022 10:54:49 GMT

When I load data from CSV file, a date field is recognized with Applied Calendars: autoCalendar. This allows to have the option to pick one of the pre-defined date functions on the field such as Year, Quarter, Month, YearMonth...

However, when I load data through load editor, a date field is not recognized as a date and the pre-defined date functions do not appear for it.

In the data I load, the date format is yyyy-mm-dd.

I tried in my load editor script to force the conversion to date but Qlik still not recognizing the field as date (no pre-defined date functions):

Date(Date#(date,'yyyy-mm-dd'),'yyyy-mm-dd')

Re: Load date with pre-defined date functions

vinieme12 — Wed, 16 Nov 2022 03:01:09 GMT

Try adding below at the end of the script

Tag Field <FIELDNAME> With $date

Re: Load date with pre-defined date functions

Lech_Miszkiewicz — Wed, 16 Nov 2022 03:12:25 GMT

This article explains how derived fields work. Date fields must be tagged as $date prior to that part of script run

How to create on your own an Autocalendar (Derived... - Qlik Community - 1716542