Resolving A Script Error

[jworthulf]

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,

JW

troyansky‌

[felipedl · Accepted solution]

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.

[Oleg_Troyansky]

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

[jworthulf]

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,

JW

troyansky‌

[Oleg_Troyansky]

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

[jworthulf]

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

[jworthulf]

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‌

[Oleg_Troyansky]

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

[felipedl]

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.