pass parameter from load script to macro function

Wed, 14 Dec 2011 19:26:12 GMT

i am trying to pass parameters from scrip (inside load statment) to macro function and i can't get the return parameter.

the parameters are array like '1,2,3,4,' and '100,0,20,0,' and '10'

my load scrip:

Result:

Load
key,
Get_num_in_array(MrpKeyArray,QtyDemandArray,QtySuplly) AS Demand_Supply_Key
Resident mrp ;

my function:

function Get_num_in_array(MrpKeyArray,QtyDemandArray,QtySuplly) 
a=split(QtyDemandArray,",")
b=QtySuplly
c=split(MrpKeyArray,",")

For x=0 to UBound(a)-1
if QtySuplly => a(x) then
QtySuplly = QtySuplly - a(x)
ResultDemandQty = ResultDemandQty & a(x)  & ","
resultDemandKey = resultDemandKey & c(x)  & ","
else
ResultDemandQty =ResultDemandQty & QtySuplly  & ","
resultDemandKey = resultDemandKey & c(x) & ","
end if
next
Get_num_in_array = resultDemandKey & ResultDemandQty 
End function

plaese help me.

Thanks in advance

Re: pass parameter from load script to macro function

fosuzuki — Tue, 31 Jul 2012 19:50:58 GMT

Hi,

It seems to be working for me.

Check the attached qvw.

Can you send a sample qvw?

Fernando

topic Re: pass parameter from load script to macro function in QlikView

pass parameter from load script to macro function

Re: pass parameter from load script to macro function