search

RobWunderlich / Qlikview-Components

A library for common Qlikview Scripting tasks
197 stars 99 forks source link

Qvc.Calendar #75

Open GorumDerVan opened 6 years ago

GorumDerVan commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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

RobWunderlich commented 6 years ago

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 commented 6 years ago

P. S. 🍺

RobWunderlich notifications@github.com 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 https://github.com/RobWunderlich/Qlikview-Components/issues/75#issuecomment-401048402, or mute the thread https://github.com/notifications/unsubscribe-auth/AlDsxbykfWyhkcmvEA2jFdlJr-qXXpObks5uBOPvgaJpZM4TaEt5 .

AngelSousa commented 5 years ago

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 commented 5 years ago

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 notifications@github.com 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 https://github.com/RobWunderlich/Qlikview-Components/issues/75#issuecomment-424227699, or mute the thread https://github.com/notifications/unsubscribe-auth/AFznhItm97SADt5p7ovq9ZMVo1j-XDH9ks5uedLhgaJpZM4TaEt5 .

AngelSousa commented 5 years ago

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

RobWunderlich commented 5 years ago

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 notifications@github.com 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 https://github.com/RobWunderlich/Qlikview-Components/issues/75#issuecomment-424599538, or mute the thread https://github.com/notifications/unsubscribe-auth/AFznhFC2TMjJPCZTnAMW1cBG-y8C69MOks5uex4HgaJpZM4TaEt5 .

AngelSousa commented 5 years ago

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 commented 5 years ago

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 notifications@github.com 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 https://github.com/RobWunderlich/Qlikview-Components/issues/75#issuecomment-424742288, or mute the thread https://github.com/notifications/unsubscribe-auth/AFznhEwTyPmffEWps_lXjQDiLrTRRON2ks5ue5MLgaJpZM4TaEt5 .