Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
It seems to be that a field containing a date > 18.01.2080 gets not tagged with $date:
Dates after year 2079 do not work
This leads into several problems. I can rebuild the issue with Qlik Sense version Sept. 2017 SR1.
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='de-DE';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan.;Feb.;März;Apr.;Mai;Juni;Juli;Aug.;Sep.;Okt.;Nov.;Dez.';
SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember';
SET DayNames='Mo.;Di.;Mi.;Do.;Fr.;Sa.;So.';
SET LongDayNames='Montag;Dienstag;Mittwoch;Donnerstag;Freitag;Samstag;Sonntag';
Data:
Load
Document,
Date(Date#(Start_Date,'DD.MM.YYYY')) AS Start_Date,
Date(Date#(End_Date,'DD.MM.YYYY')) AS End_Date
Inline [
Document,Start_Date,End_Date
A,05.10.2015,31.12.2055
B,12.10.2016,31.12.2079
C,06.06.2017,19.01.2080
];
Calendar:
DECLARE FIELD DEFINITION TAGGED '$date'
Parameters first_month_of_year = 1
Fields
Year($1) As Year Tagged ('$numeric'),
Month($1) as Month Tagged ('$numeric'),
Date($1) as Date Tagged ('$date'),
Week($1) as Week Tagged ('$numeric'),
Weekday($1) as Weekday Tagged ('$numeric'),
DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric')
Groups
Year, Week, Weekday type drilldown as YearWeekDayName,
Year, Month, Date type collection as YearMonthDate;
DERIVE FIELDS FROM FIELDS Start_Date,End_Date USING Calendar;
An explicite tagging of the field seems to be a workaround:
Tag End_Date With $timestamp, $date;