Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jworthulf
Creator
Creator

Resolving A Script Error

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

1 Solution

Accepted Solutions
felipedl
Partner - Specialist III
Partner - Specialist III

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.

View solution in original post

8 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator
Creator
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator
Creator
Author

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
Creator
Creator
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Specialist III
Partner - Specialist III

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.