Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rbecher
MVP
MVP

Qlik Sense issue with dates after 01/18/2080

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;

Start_Date.png

End_Date.png

Astrato.io Head of R&D
Labels (3)
1 Reply
rbecher
MVP
MVP
Author

An explicite tagging of the field seems to be a workaround:

Tag End_Date With $timestamp, $date;

Astrato.io Head of R&D