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