Qvc.Calendar about qlikview-components HOT 13 OPEN

These semantic errors surfaced with QV 12.20. while I'm figuring out how to eliminate them completly, a workaround is to add this as the first line of your script file:

///$bnf off

from qlikview-components.

Thank you Rob for the quick reply. I added the statement as the very first line in the script but the errors remain.
QV 12 SR3
12.20.20400.00
I'll wait for the update of QlikView and keep an eye on the github.

Thanks for your great components library!

from qlikview-components.

It looks like your Cal_test table possibly has no rows. Can you check the script log and see if any rows were created?

from qlikview-components.

Cal_test:
Load
2018-04-18 16:17:23 0038 Date(26299+iterno()-1) as Date
2018-04-18 16:17:23 0039 AutoGenerate(1)
2018-04-18 16:17:23 0040 While iterno()-1 <= 44561 - 26299
2018-04-18 16:17:23 1 fields found: Date,
2018-04-18 16:17:23 18.263 lines fetched

from qlikview-components.

I get the same error
Autogenerate: generate count is out of range
LOAD FieldValue('',recno()) as [] AUTOGENERATE FieldValueCount('')
Any news on this issue?

from qlikview-components.

I have unable to recreate this problem or get any further information on it, although someone else has reported it. The issue seems to be that the start date is null but I don't know why. Can you post the entire script log?

from qlikview-components.

from qlikview-components.

I solved the date-format issue.. but now.... trying to CALL the QVC gives me these:

Invalid Autogenerate count: -1e+300
LOAD FieldValue('', recno()) as [] AUTOGENERATE FieldValueCount('')
Table not found
DROP TABLES statement
Invalid Autogenerate count: -1e+300
LOAD date('' + recno() - 1) as Date,
date('' + recno() - 1) as _qvctemp.Date
AUTOGENERATE date('') - date('') + 1

_qvctemp.Calendar.EscapeCharsMap << d7ffbd5e-bb4a-4791-8b5e-36e3e0f5e22d 2 Lines fetched

FOR _qvctemp.i = 1 to NoOfFields('MasterCalendar')

<<<<<<
Unexpected token: 'MasterCalendar', expected nothing
LET _vClearFieldList = '' & '[' & FieldName(, >>>>>>'MasterCalendar'<<<<<<) & ']=,'
The control statement is not correctly matched with its corresponding start statement
NEXT _qvctemp.i

FOR _qvctemp.i = 1 to NoOfFields('MasterCalendar')

<<<<<<
Unexpected token: 'MasterCalendar', expected nothing
LET _qvctemp.vFname = FieldName(, >>>>>>'MasterCalendar'<<<<<<)
The control statement is not correctly matched with its corresponding start statement
NEXT _qvctemp.i

from qlikview-components.

from qlikview-components.

$(Include=C:\Program Files\QlikView\QlikviewComponents-11.2\Qvc_Runtime\qvc.qvs);
CALL Qvc.CalendarFromField(Plantilla_Date);

from qlikview-components.

from qlikview-components.

Invalid Autogenerate count: -1e+300
LOAD FieldValue('Plantilla_Date', recno()) as [Plantilla_Date] AUTOGENERATE FieldValueCount('Plantilla_Date')
Table not found
DROP TABLES statement
Invalid Autogenerate count: -1e+300
LOAD date('' + recno() - 1) as Date,
date('' + recno() - 1) as _qvctemp.Date
AUTOGENERATE date('') - date('') + 1

_qvctemp.Calendar.EscapeCharsMap << bbfab722-5ffb-4c3d-acf5-9c87ff549eb1 2 Lines fetched

FOR _qvctemp.i = 1 to NoOfFields('MasterCalendar')

<<<<<<
Unexpected token: 'MasterCalendar', expected nothing
LET _vClearFieldList = '' & '[' & FieldName(, >>>>>>'MasterCalendar'<<<<<<) & ']=,'
The control statement is not correctly matched with its corresponding start statement
NEXT _qvctemp.i

FOR _qvctemp.i = 1 to NoOfFields('MasterCalendar')

<<<<<<
Unexpected token: 'MasterCalendar', expected nothing
LET _qvctemp.vFname = FieldName(, >>>>>>'MasterCalendar'<<<<<<)
The control statement is not correctly matched with its corresponding start statement
NEXT _qvctemp.i

from qlikview-components.

from qlikview-components.