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.

Not applicable

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

Tags (3)