Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

amit_saini
Not applicable

General Script error Help????

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,

AS

Tags (1)
3 Replies
tresesco
Not applicable

Re: General Script error Help????

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.

amit_saini
Not applicable

Re: General Script error Help????

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 D: 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,

AS

tresesco
Not applicable

Re: General Script error Help????

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