8 Replies Latest reply: Aug 30, 2017 1:57 PM by Felip Drechsler RSS

    Resolving A Script Error

    John Worth

      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

        • Re: Resolving A Script Error
          Felip Drechsler

          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

          [C:\Users\jworth\OneDrive for Business\My Documents\My Documents\On going\Qlikview\2017\Qlikview Book\Qlikview Your Business\Data\QVDs\ShipToMaster.QVD]

          (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

          [C:\Users\jworth\OneDrive for Business\My Documents\My Documents\On going\Qlikview\2017\Qlikview Book\Qlikview Your Business\Data\QVDs\ShipToMaster.QVD]

          (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.