topic Re: Script Line error in QlikView

Script Line error

buederbenjamin — Tue, 29 Nov 2016 16:24:16 GMT

Hi everyone,

I want to call a sub routine in my script. When the "call" statement is include in a IF, the script works correctly but when it's called as an independent instruction I get this error message: "Script Line Error".

Does anyone have an idea?

Thanks a lot,

Re: Script Line error

vishsaggi — Tue, 29 Nov 2016 16:30:19 GMT

Can you share some more information here please. Like a snapshot of your error and the subroutine you are using ?

Re: Script Line error

buederbenjamin — Tue, 29 Nov 2016 16:40:02 GMT

Thank you Vishwarath,

here is my sub routine:

SUB Purge_Load_Status

Load_Status_Max_Year:

Load

Max(Year(Load_Date)) as MaxYearLoadStatus

From [$(_File_Load_Status)](qvd);

let maxDateLoadStatus = peek('MaxYearLoadStatus', 0, 'Load_Status_Max_Year'); //MaxDate chargée

Drop table Load_Status_Max_Year;

NoConcatenate

Load_Status:

Load *

From [$(_File_Load_Status)](qvd)

Where Year(Load_Date)>=($(maxDateLoadStatus)-2);

Store Load_Status into [$(_File_Load_Status)](qvd);

END SUB

Re: Script Line error

vishsaggi — Tue, 29 Nov 2016 16:48:34 GMT

Any specific reason you need a subroutine here? Cant you just run the LOAD as is. However, where is the IF you are using here? I dont find anything wrong with the LOAD script. Can we know what exactly you were trying to achieve ?