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

Wed, 14 Mar 2012 11:28:17 GMT

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

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

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