Qvc.Calendar

[GorumDerVan]

Downloaded the current version.
Error creating calendar using this call statement: CALL Qvc.CalendarFromField ('Date') on this test script:
LET MinDate = num(MakeDate(1972));
LET MaxDate = num(MakeDate(Year(addyears(Today(), 3))));
Cal_test:
Load
Date($(MinDate)+iterno()) as Date
AutoGenerate(1)
While iterno() <= $(MaxDate) - $(MinDate) ;

Error is:
Semantic error
CALL Qvc.GetFieldValues('_vStats', 'Date')
followed by
Syntax error
Unexpected token: ',', expected one of: '(', 'ZTestw_z', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'not', 'bitnot', 'LITERAL_NUMBER', ...
LET _concatenate = if(>>>>>>,<<<<<< 'CONCATENATE ([MasterCalendar])', '')
followed by
Autogenerate: generate count is out of range
LOAD date('' + recno() - 1) as Date,
date('' + recno() - 1) as _qvctemp.Date
AUTOGENERATE date('') - date('') + 1

Commented the call statement Qvc.GetFieldValues in the script but that didn't help.

Thanks for your help.

[RobWunderlich]

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

[GorumDerVan]

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!

[RobWunderlich]

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

[GorumDerVan]

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

[idenne]

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

[RobWunderlich]

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?

[idenne]

P. S. 🍺 RobWunderlich <[email protected]> schrieb am Do., 28. Juni 2018, 16:10:

…

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? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#75 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AlDsxbykfWyhkcmvEA2jFdlJr-qXXpObks5uBOPvgaJpZM4TaEt5> .

[AngelSousa]

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

[RobWunderlich]

Can you post your CALL statement? Kind Regards, Rob Wunderlich http://MastersSummit.com @QlikMasters http://QlikviewCookbook.com @QVCookbook http://www.easyqlik.com QViewer

…

On Mon, Sep 24, 2018 at 11:53 PM AngelSousa ***@***.***> wrote: 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 — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#75 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFznhItm97SADt5p7ovq9ZMVo1j-XDH9ks5uedLhgaJpZM4TaEt5> .

[AngelSousa]

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

[RobWunderlich]

Date field should be quoted. CALL Qvc.CalendarFromField('Plantilla_Date'); Kind Regards, Rob Wunderlich http://MastersSummit.com @QlikMasters http://QlikviewCookbook.com @QVCookbook http://www.easyqlik.com QViewer

…

On Tue, Sep 25, 2018 at 11:26 PM AngelSousa ***@***.***> wrote: $(Include=C:\Program Files\QlikView\QlikviewComponents-11.2\Qvc_Runtime\qvc.qvs); CALL Qvc.CalendarFromField(Plantilla_Date); — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#75 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFznhFC2TMjJPCZTnAMW1cBG-y8C69MOks5uex4HgaJpZM4TaEt5> .

[AngelSousa]

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

[RobWunderlich]

Plantilla_Date does exist and has values? If so, try adding *///$bnf off* as the first line of your script. Kind Regards, Rob Wunderlich http://MastersSummit.com @QlikMasters http://QlikviewCookbook.com @QVCookbook http://www.easyqlik.com QViewer

…

On Wed, Sep 26, 2018 at 7:45 AM AngelSousa ***@***.***> wrote: 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 — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#75 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFznhEwTyPmffEWps_lXjQDiLrTRRON2ks5ue5MLgaJpZM4TaEt5> .