Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies