0 Replies Latest reply: Mar 14, 2012 7:28 AM by alighieri RSS

    launching a function or macro in load script doesn't work

      I just tried to launch a function and a macro of a module from inside the load script by copying the example in the Reference Manual of Qlikview Version 11

      (italian version:  81 Chiamate di funzioni VBScript dallo script, pag. 899)

      but the function call doesn't work and the sub call issues an error message.

       

      my  macro module is:

      function func1()

      prompt="insert a number"

      func1=inputbox(prompt)

      end function

       

      sub msg1()

      msgbox "ready"

      end sub

       

      my load script is:

      SET ThousandSep='.';

      SET DayNames='lun;mar;mer;gio;ven;sab;dom';

      call msg1(); //this issues an error

      let num=func1();  //this doesn't show any inputbox

      Directory;

      LOAD 

           Article_id,

           Category,

           func1() as pop, //pop remains undefined

           Sale_price

      FROM

      C:\SH_Tecnica\QLIK\efashion_QV\efashion_of2003.xls

      (biff, embedded labels, table is Article_color_lookup$);

       

      Can anyone explain me where am I wrong or which preferences/ioptions should be set?

      thanks