Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik_user2
Contributor
Contributor

How to include leap year (data from 29.02.2020 does get loaded)

Hi there

I have customer data stored in a Excel sheet. It is basically a order number and a delivery date.

Since 2020 is a leap year, the 29th of February (29.02.2020) exists but the problem is that it is not loaded from my script.

Is there a easy way to fix this?

Thanks, in advance!

my autoCalendar script looks like this:

date.PNG

 

1 Solution

Accepted Solutions
Mauritz_SA
Partner
Partner

Hi there

Why are you showing the autocalendar script? Are the autocalendar fields not derived for the 29 Feb dates or are the 29 Feb dates not loaded at all? If the entries for 29 Feb are missing then I don't think it's an autocalendar problem.

Regards,

Mauritz

View solution in original post

1 Reply
Mauritz_SA
Partner
Partner

Hi there

Why are you showing the autocalendar script? Are the autocalendar fields not derived for the 29 Feb dates or are the 29 Feb dates not loaded at all? If the entries for 29 Feb are missing then I don't think it's an autocalendar problem.

Regards,

Mauritz