topic Re: Script Error in QlikView

Script Error

Fri, 10 May 2013 12:12:29 GMT

Hi guys plz help me on this,I am new to this..this error is coming when I am clicking the reload button in the script.

.I am taking the data from a BI cube.PFA the script also.

Thanks in advance for the help

Field not found - <_0DIVISION>

FINAL:

LOAD _0DIVISION,

_0MATERIAL,

_0MATL_GROUP,

_0MAT_DOC,

_0PLANT,

_0SUPPLIER,

_0FISCVARNT,

_0CURRENCY,

_0UNIT,

Measures_0PRICE_UNIT,

Measures_Z_AC_SAVE,

Measures_Z_FR_PR,

Measures_Z_FR_QTY,

Measures_Z_FR_SPND

FROM

[http://localhost:8085/?name=final]

(txt, utf8, embedded labels, delimiter is ',')

Re: Script Error

juleshartley — Fri, 10 May 2013 12:16:33 GMT

It looks like the error says - it can't find that field. Are you sure it's named correctly? Being the first field it may mean that it can't read the data source... are you sure it is connecting? Can you try and return just one of the other fields?

Re: Script Error

Tue, 14 May 2013 07:16:54 GMT

Yes I have checked it with the other fields also..Its giving the same error again.And also I checked for the connection also.

Re: Script Error

er_mohit — Tue, 14 May 2013 07:49:01 GMT

IfYou must know the error because of this field

then try to enclose that field in square bracket i think it because of space

[_0DIVISION]

hope it helps

Re: Script Error

juleshartley — Tue, 14 May 2013 08:44:36 GMT

I would try a 'load * from' first. If this fails then it is your data connection - so you need to rebuild that.

perhaps specify the server instead of using localhost?

Re: Script Error

Tue, 14 May 2013 08:53:32 GMT

Yes I have checked it with the other fields also..Its giving the same error again.And also I checked for the connection also.

Re: Script Error

Tue, 14 May 2013 09:18:47 GMT

I think , you write your field inside this [ ] bracket.

Re: Script Error

Tue, 14 May 2013 13:57:41 GMT

Guys I appreciate ur answers and efforts..But none of the suggestions are working

Re: Script Error

Tue, 14 May 2013 13:57:54 GMT

Guys I appreciate ur answers and efforts..But none of the suggestions are working

Re: Script Error

Tue, 14 May 2013 13:58:19 GMT

Guys I appreciate ur answers and efforts..But none of the suggestions are working

Re: Script Error

Anonymous — Tue, 14 May 2013 14:09:09 GMT

Try:

LOAD _0MATERIAL,
_0DIVISION,

_0MATL_GROUP,

_0MAT_DOC,

_0PLANT,

_0SUPPLIER,

_0FISCVARNT,

_0CURRENCY,

_0UNIT,

Measures_0PRICE_UNIT,

Measures_Z_AC_SAVE,

Measures_Z_FR_PR,

Measures_Z_FR_QTY,

Measures_Z_FR_SPND

FROM

[http://localhost:8085/?name=final]

(txt, utf8, embedded labels, delimiter is ',')

You probebly now get an error on _0MATERIAL , right?

If that is the case your problem is not the field names but it is in the FROM-part (because it justs gives an error on the first field it is trying to load)

Re: Script Error

rwunderlich — Tue, 14 May 2013 14:29:10 GMT

Did you generate this script statement using the wizard? Usually when loading from http there is a "table is n" parm that specifies the html table number.

-Rob

Re: Script Error

Thu, 16 May 2013 12:02:27 GMT

Hi Rob

I did not understand what is 'table is n' parm..plz can u xplain

and I think that I am getting this error bocz of some local host issue..Do we need to do some extra configurations for Qlikview?

Re: Script Error

Thu, 16 May 2013 12:04:54 GMT

Hi Rob

I did not understand what is 'table is n' parm..plz can u xplain

and I think that I am getting this error bocz of some local host issue..Do we need to do some extra configurations for Qlikview?

Re: Script Error

Anonymous — Thu, 16 May 2013 12:07:20 GMT

More improtant is the first part of Rob's question ; "Did you generate this script statement using the wizard? "

Normaly using the wizard will get you the right script.

Re: Script Error

Thu, 16 May 2013 12:14:16 GMT

No I guess...Can you plz tell me how do I generate script using Wizard..I am using xtract QV to generate the script..then I paste that in Qlikview..

Re: Script Error

Anonymous — Thu, 16 May 2013 12:30:09 GMT

When you go to the load script (CTRL+e)

Choose below the button "Internet files" This will open the wizard.

Re: Script Error

Thu, 16 May 2013 12:50:04 GMT

Yes ok I have opened the Wizard...then what do I put in that ? I need to take data from SAP BI

Re: Script Error

Thu, 16 May 2013 13:11:10 GMT

Yes ok I have opened the Wizard...then what do I put in that ? I need to take data from SAP BI

Re: Script Error

Anonymous — Thu, 16 May 2013 14:59:57 GMT

I dont know SAP BI but if I see your previous script it looks like you are trying to connect to a url, right?

So see what happens if you fill in:

http://localhost:8085/?name=final

in the Internet file field.....