General Script error Help????

amit_saini — Mon, 06 Oct 2014 04:54:32 GMT

Hi Folks,

This application attached is working from many days , suddenly getting General Script error. Please see the attached log file and kindly help.

Thanks,

Re: General Script error Help????

tresB — Mon, 06 Oct 2014 05:16:02 GMT

I would comment out the last reload excel 'Hierarchie.xlsx' and retry. If it goes fine, have a look at that file; refresh it; save it and retry with full script.

Re: General Script error Help????

amit_saini — Mon, 06 Oct 2014 06:23:08 GMT

Tresesco,

I found one strange issue , if I use F: drive path to call script below it is showing general script error but If I comment this and run this script from 😧 drive path it is working fine . Could you please suggest what could be issue here.

//for each file in filelist('D:\QlikView\Development\Finance\#Source\Flatfiles\Sonne\Source\*')

for each file in filelist('F:\QlikView\Server\SourceDocuments\Finance\#Source\Flatfiles\Sonne\Source\*')

Sales_Data_Temp:

CrossTable(Sales_Month, Sales_Data,2)

LOAD

subfield(subfield('$(file)', '\' ,10),'.',1) as Sales_Year ,

trim(Plant) as %Plant,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

/* F14,

F15,

F16,

F17,

F18,

F19,

F20,

F21,

F22,

F23,

F24,

F25,

F26,

F27,

F28,

F29

FROM

[$(file)]

(ooxml, embedded labels, table is Sales, filters(

Remove(Row, Pos(Top, 8)),

Remove(Row, Pos(Top, 7)),

Remove(Row, Pos(Top, 6)),

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 4)),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2)),

Remove(Col, Pos(Top, 1)),

Remove(Col, Pos(Top, 3)),

Remove(Col, Pos(Top, 2)),

Remove(Col, Pos(Top, 15)),

Remove(Col, Pos(Top, 14)),

Remove(Col, Pos(Top, 34)),

Remove(Col, Pos(Top, 33)),

Remove(Col, Pos(Top, 32)),

Remove(Col, Pos(Top, 31)),

Remove(Col, Pos(Top, 30)),

Remove(Col, Pos(Top, 29)),

Remove(Col, Pos(Top, 28)),

Remove(Col, Pos(Top, 27)),

Remove(Col, Pos(Top, 26)),

Remove(Col, Pos(Top, 25)),

Remove(Col, Pos(Top, 24)),

Remove(Col, Pos(Top, 23)),

Remove(Col, Pos(Top, 22)),

Remove(Col, Pos(Top, 21)),

Remove(Col, Pos(Top, 20)),

Remove(Col, Pos(Top, 19)),

Remove(Col, Pos(Top, 18)),

Remove(Col, Pos(Top, 17)),

Remove(Col, Pos(Top, 16)),

Remove(Col, Pos(Top, 15)),

Remove(Col, Pos(Top, 14)),

Top(1, 'Plant')

));

Thanks,

Re: General Script error Help????

tresB — Mon, 06 Oct 2014 06:42:13 GMT

It could be access/path issue. Try to explore the file once again from the script editor browser and retry.

topic General Script error Help???? in QlikView

General Script error Help????

Re: General Script error Help????

Re: General Script error Help????

Re: General Script error Help????