topic Re: Error in script in QlikView

Error in script

mario-sarkis — Wed, 04 Mar 2015 15:23:52 GMT

while i am running the script an error appear (Script line error: let vQA) please find attach file. If you can tell why

Thanks

Re: Error in script

rubenmarin — Wed, 04 Mar 2015 15:27:23 GMT

Hi mario, is this the entire line in the script? "let vQA"?.

Most probably it's because you didn't end the previous sentence with a semicolon (;), otherwise must be something with that let sentence, if this is the case, I'll need to see the entire sentence in script.

Re: Error in script

mario-sarkis — Wed, 04 Mar 2015 15:33:44 GMT

Hi Ruben;

Once i click Releod the error appears. When i click ok the script run normaly.

anyway this my script :

CustomerValidationName:
NoConcatenate
LOAD
CIFID ,
CIFTYPE,
CIFTYPE2,
CIFSHRTNM

From $(vCustomersExtractionFile).qvd(qvd);

CustomerClas:
NoConcatenate
LOAD
CIFID as [AccID],
CIFTYPE as [Customer Val Type],
CIFTYPE2 as [Customer Val Type2],
CIFSHRTNM as [Customer Val Name]

Resident CustomerValidationName;
drop Table CustomerValidationName;

Derscriprion:
Load
CDSLONCDE,
CDSLONELM,
CDSLONTAB,
trim(CDSLONDES1) as CDSLONDES1
Where (CDSLONCDE='CIF' and CDSLONTAB='SE') ;

SQL SELECT
CDSLONCDE,
CDSLONELM,
CDSLONTAB,
CDSLONDES1
FROM IASP1.VBAUMF.VCDSLON;

CustomerSegmentation:
NoConcatenate
Load
    CIFEXCLSE,
    CIFEXCOB,
    CIFEXGIIN,
    CIFEXID,
    CIFEXIN,
    IF(NOT ISNULL(CIFEXPEBA),CIFEXPEBA) AS CIFEXPEBA,
    CIFEXPEBR,
    CIFEXPOGCN,
    CIFEXPOMCN,
    CIFEXPOPCN,
    CIFEXPOSCN,
    CIFEXTFIL,
    CIFEXUPBA;

SQL SELECT
    CIFEXCLSE,
    CIFEXCOB,
    CIFEXGIIN,
    CIFEXID,
    CIFEXIN,
    CIFEXPEBA,
    CIFEXPEBR,
    CIFEXPOGCN,
    CIFEXPOMCN,
    CIFEXPOPCN,
    CIFEXPOSCN,
    CIFEXTFIL,
    CIFEXUPBA
FROM IASP1.VBKCIF.VCIFEXTPF;

CustomerSegmentation1:
NoConcatenate
Load
CIFEXID as [AccID],
CIFEXCLSE,
CIFEXPEBA,
CIFEXPEBR
resident CustomerSegmentation
where (CIFEXPEBR='023' or CIFEXPEBR='078');
drop table CustomerSegmentation;
rename table CustomerSegmentation1 to CustomerSegmentation;

CS:
Load
[AccID],
CIFEXCLSE as CDSLONELM,
trim(CIFEXPEBA) as CIFEXPEBA,
CIFEXPEBR
Resident CustomerSegmentation;
Drop table CustomerSegmentation;
rename table CS to CustomerSegmentation;

left join(CustomerSegmentation)
Load CDSLONCDE,
CDSLONELM,
CDSLONTAB
Resident Derscriprion ;
Drop table Derscriprion;

left join(CustomerSegmentation)
LOAD * Resident CustomerClas;
drop table CustomerClas;

Thank you

Re: Error in script

rubenmarin — Wed, 04 Mar 2015 15:41:15 GMT

Hi Mario, I didn't see any 'let' sentence here and I don't think it's part of vCustomersExtractionFile.

Can you double-check if there is a previous tab and/or hidden script where this sentence appears?. Maybe it's betwwen the firsts SET sentences in the Main tab.

To check if there is a hidden script you can check, insede the script--> file menu--> If the 'Edit hidden script...' option is active, there is a hidden script.

Re: Error in script

mario-sarkis — Wed, 04 Mar 2015 15:49:05 GMT

Hi Ruben this is what i have in the MAIN First Tab , and i dont have any hidden script.

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

$(include=../includes/QVD_Paths.txt);

Thank you

Re: Error in script

awhitfield — Wed, 04 Mar 2015 15:51:41 GMT

Check what's in the include file.

Re: Error in script

rubenmarin — Wed, 04 Mar 2015 15:59:08 GMT

Yes, in ../includes/QVD_Paths.txt should exists that let, check if the previous sentence has his semicolon at the end or post the content of the file if vQA is calculated using previous variable values.

Re: Error in script

mario-sarkis — Thu, 05 Mar 2015 08:44:36 GMT

Thank you Ruben for Your help.

you were right had prob with ../includes/QVD_Paths.txt