topic Re: Resolving A Script Error in QlikView

Resolving A Script Error

jworthulf — Fri, 18 Aug 2017 19:05:04 GMT

I'm new to Qlikview and I've been reading a book "QlikView Your Business". I've inserted a script text file into a QVW I'm working on and I've run into a script error that I haven't been able to fix.

If you go to the script & run the debugging program (Animate) the first error shows up on line 317. The script file is referenced in the main tab and was downloaded with the book I'm readying. I'm not familiar with the Qlik syntax & I haven't been able to find a solution to the error(s) that pop up starting with line 317. Looking for a little help.

Thanks,

troyansky‌

Re: Resolving A Script Error

felipedl — Fri, 18 Aug 2017 19:34:03 GMT

Hi John

I guess you forgot to name a table, the table Shipto on the dimensions tab

Its like this

LOAD [Ship To ID],

[Customer ID],

Name,

[Address 1],

[Address 2],

[Address 3],

City,

State,

Country,

[ZIP Code],

[ShipTo Start Date],

[ShipTo End Date]

FROM

(qvd);

And should be named to

ShipTo:

LOAD [Ship To ID],

[Customer ID],

Name,

[Address 1],

[Address 2],

[Address 3],

City,

State,

Country,

[ZIP Code],

[ShipTo Start Date],

[ShipTo End Date]

FROM

(qvd);

So that when you do

LEFT JOIN

(Fact)

LOAD

[Ship To ID],

[ShipTo Start Date],

[ShipTo End Date]

Resident

ShipTo

;

it finds the table (probably the message error your getting is Qlik can't find the table ShipTo on the resident load).

Felipe.

Re: Resolving A Script Error

Oleg_Troyansky — Sun, 20 Aug 2017 13:34:07 GMT

Hi Felipe,

thank you for stepping in and answering the question while I was away... Good catch, too!

John, if this solution doesn't solve all the problems, please respond, and we will dig deeper.

cheers,

Oleg Troyansky

Re: Resolving A Script Error

jworthulf — Mon, 21 Aug 2017 14:07:29 GMT

Felipe

Thanks for the help your response resolved the error. I ran the script this morning with the update & I have one more error popping up in the Master Calendar Tab line 32. I've attached the updated script and I hoping you or Oleg can help with this error.

Thank you,

troyansky‌

Re: Resolving A Script Error

Oleg_Troyansky — Tue, 22 Aug 2017 20:14:29 GMT

Hi John,

the issue is that you don't have a field named Date in the Fact table. Hence, the LOAD statement must be failing with the error "Field Not Found". You can find the correct script in the solution file "10.10c Sales Transformation Script.QVW" in the folder \Solutions QlikView\. In this folder, you can find solutions for each and every exercise in the book (isn't it great?).

Notice the addition of the field Date in the Sales tab of the load script.

Anyone who is interested in learning advanced Qlik techniques using a detailed hands-on tutorial, check out my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense.

cheers,

Oleg Troyansky

Re: Resolving A Script Error

jworthulf — Thu, 24 Aug 2017 16:36:38 GMT

Oleg,

Thanks for identifying the issue I reloaded the data & it worked! The solutions file ....I missed that somewhere in the book so I haven't been using it....going forward it's going to be a big help thanks for pointing this out and for all of your help!

Appreciated,

John

Re: Resolving A Script Error

jworthulf — Mon, 28 Aug 2017 12:03:38 GMT

Oleg,

The script is not showing any more errors however it is not loading the transformed files. When I load the script it runs w/out any errors but I get an "execution of script failed" error at the end. I've attached a copy of my updated file.

troyansky‌

Re: Resolving A Script Error

Oleg_Troyansky — Wed, 30 Aug 2017 17:52:06 GMT

I think the problem is in the incorrectly specified path for the folders:

Let vQVDPath= '..Data\QVDs\';

Let vTransformedQVDPath= '..Data\Transformed QVDs\';

If you follow the same set of folders as suggested in the book, the correct path should look like this:

Let vQVDPath= '..\Data\QVDs\';

Let vTransformedQVDPath= '..\Data\Transformed QVDs\';

If you get stuck again, I suggest to copy the corresponding solution file from the foder \Solutions QlikView\ and move along.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

Re: Resolving A Script Error

felipedl — Wed, 30 Aug 2017 17:57:41 GMT

I agree with Oleg,

could be some path that isn't right,

I've seen that you commented the code for the sub StoreAllTablesIntoQVDs and on line 18 of the "Generate QVDs" you're calling the sub.

Try commenting the sub also, could be the problem that you're making a call to a sub Qlik doesn't know.

Felipe.