Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion board where members can learn more about Qlik Sense Data Connectivity.
Hi there,
I have implemented a canonical calendar and master calendar per some information I found online which utilizes a sub routine to spawn off the common calendar and optionally you can spawn off master calendars for each date attribute.
For some reason when I try and create the master calendars it fails due to an out of range value:
The following error occurred:
Autogenerate: generate count is out of range
The error occurred here:
LOAD FieldValue('BirthDate', RecNo()) as datefield AutoGenerate FieldValueCount('BirthDate'
I've had a look at the date field data in the SQL Server database and it is a date datatype, and there are no "odd" looking values in there. I've also done an ORDER BY in my load, neither of these seem to resolve the issue. Can anybody explain what can cause an out of range error when handling dates? I suspect that Qlik is doing something under the hood?
Thanks!